AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N95293Okraska Raymond H · Somers, CTN95296Gravenstede Nelson F · Newton, NJN9529VPatterson Roland O · Semmes, ALN95308Mcguire Robert E · Arrey, NMN9530VPeter Giller Aer LLC · Hackettstown, NJN9531ASpeirs Colin Jackson · San Luis Obispo, CAN9531SUpland Amy L · Miami Springs, FLN9532ASchiller Darryl L · Belton, TXN9533APeterson Kristofor J · Talkeetna, AKN9534AWren James T · Gilbert, AZN9534SBall Ronald C · Colby, KSN9535VSamaritan Aviation · Mesa, AZN9536VSchwartz Robert E · Troy, OHN95373Plyler Aviation Lp · Sherman, TXN9537VBichell Kevin C · Corsicana, TXN9538ASale Reported · Orlando, FLSale reportedN9538SClark William · Easton, MON9538VJones Wesley A · Ocala, FLN9539SFox Norman A · Maryville, TNN9539VBrown Stephen C · Gosport, INN953HAEkstrom Benjamin G · Anchorage, AKN953JTThompson James S · Marine, ILN9540AAlder George A · Palmer, AKN9540SNeufeld Maria · Seminole, TXN9541VIowa Mooney Sales Inc · Radcliffe, IAFirst renewal noticeN9543STherkelsen Robert D · Burlington, WAN9543VRobinson Phillip L · Cabot, ARN9544ADaugherty Lee H · Charleston, WVRegistration revokedN9545AJetl Aviation LLC · Southern Pines, NCN9545VWeber Stephen J · Hastings, MNN9546AStevens Scott D · Corsicana, TXN9547AChristiansen Brent D · Mabton, WAN9547VAerospace Trust Management LLC Trustee · Wilmington, DEN9549SZippy Airways LLC · Columbus, OHN9549VRomeo-Delta Inc · Elsie, MIN954RDKing James E · Port Angeles, WAN954ZSmith Richard L · Sequim, WAN9551SBerberich John E · Wasilla, AKN9551VTarheel Aircraft Inc · Richlands, NCN95535Hadley Acft Inc · S Plainfield, NJRegistration revokedN9554ABagley James L · Pampa, TXN95559Wilcox Darrol A · Nenana, AKN9555SMcquillin Duane C · Palmer, AKN9558SKansas Air LLC · Linn, KSN9559AGrace'S Wings LLC · Crystal Lake, ILFirst renewal noticeN955RSDuck Troy · Kannapolis, NCN955ZBritton Benjamin J · Austin, TXN9561SFerguson Glen P · Cascade, MTN95632Reid Robert W · Independence, ORN9563SMumm Paul D · Geneva, NE
Back to AD 94-05-05 R1