AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N914TCSpeed Racer LLC · Port Orange, FLN914WYAcro Crazy LLC · Plymouth, MAN914ZSkylens LLC · Hammond, LAN91507Eagle Aviation LLC · Spearfish, SDN9150DFitzgerald Larry · Fairbanks, AKN9150HN9150h LLC · Charleston, SCN9150VUrness John · Oakland, CAN9150WMcmullin Chad D · Roosevelt, UTN9150YTyler Transport LLC · Troy, ALN91518Hatfield Timothy E · Parowan, UTN9151HFirst Flight Corp · San Diego, CAN9151LCerrato Michael J · Dublin, OHN9151NPlane Nonsense Inc · Middletown, DEN9151VNeret Michael G · Sugarland, TXN9151YRegistration Pending · South Jordan, UTRegistration pendingN9152KHangar 9 Inc · Aberdeen, SDN9152LBaker Glen M · El Reno, OKN9152SHomer Mark · Grosse Ile, MIN9152WTeal Water Investments LLC · Blanco, TXN9153CPax Enterprises Inc · Allen, TXN9153HSambriski Michael Daniel III · Long Beach, NYN9153JRamer Kristina · Ruskin, FLN9153SB Squared Inc · Bedford, NHN9153VRegistered aircraftN91544Piper Aircraft Inc · Vero Beach, FLN9154PSloan James M Trustee · Grandbury, TXN9154YNolan Daniel R · Wilmington, NCN91553Simpson Josiah J L Trustee · Shelburne, MAN9155CN9155c LLC · Palm Harbor, FLN9155DTaylor Glenn Maurice · Fayetteville, GAN9155VHickox Joseph C · Rollins, MTN9155WWiger Theodore L · Falcon Heights, MNN9156DTalmadge Jeffery K · New Milford, CTN9156HSolar Flying Club · Grimes, IAN9156JChristian Family Fellowship · Mesa, AZN9156SStickley Harold R · Wauseon, OHN9156VLegnaioli Richard · Cambridge, MDN9157A9k Air LLC · Newark, DEN9157CAims Community College · Greeley, CON9157EWillard James L · Prosser, WAN9157WFear David L · Hartford City, INN9158CSmith Robert A · Stillwater, OKN9158E7 J Aeroflight Publications Inc · Gruver, TXN9158HParrish Aviation Flight Academy LLC · Southlake, TXN9158VMellinger David S · Lusby, MDN9158WKirkhoff Robert A · Pottstown, PAN9158YLockwood Rick I · Garden Grove, CAN91596West Michigan Flying Club Inc · Norton Shores, MIN9159HHess Garrett · Fullerton, CAN9159KRoss Andrew · Yamhill, OR
Back to AD 81-18-04 R2