AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N360PMBon Aire Inc · Middlesboro, KYN360PSEllis Nigel R · Concord, CAN360QBSpirit Of Flight Foundation · Nampa, IDN360RGJay Services LLC · Stephenville, TXN360RHMunson Bruce E · Little Rock, ARN360RJOliver Paul D · Bozeman, MTN360RTN360rt LLC · Lewes, DEN360SBYoung Dennis L · Fort Worth, TXN360SPN360sp LLC · Palm City, FLN360SRRegistration Pending · Pleasant Grove, CARegistration pending, pending cancellationN360SXSkrock David G · Grants Pass, ORN360TThroop Greg J · Spokane, WAN360TNSamaritan Aviation · Mesa, AZN360UAdrenalyne Consulting LLC · Scottsdale, AZN360WBBaumann Wayne R · Waterford, MIN360WLLaughlin Linda · Bluff Dale, TXN360WSWood Scot L · Irvington, ALN360WY360wy LLC · Pinedale, WYN360XKPoore Curby W · Mcdonald, KSN360XPBaker Laurence Todd · Imlay City, MIN360XTThorall Patrick A · Chugiak, AKN360XXSleepy Dog LLC · Sheridan, WYN360ZRN360zr LLC · Jacksonville, FLN3610HScheffing Glenn J · Palm Beach Gardens, FLN36115Turner Randall D · Tolar, TXN36116Meriden Aviation Center LLC · Meriden, CTN36118Cg Aviation LLC · Woods Cross, UTFirst renewal noticeN3611ASgmbb LLC · Seneca, SCN3611CNicoll Steve · Bozeman, MTN3611HTavalaro Joseph DBA · Massapequa, NYN3611NDowden Frank D · Fallbrook, CAN36120United States Air Force Owner · Hanscom Afb, MAN36129Tjarks Heyo H · Dubuque, IAN3612CLipka Will · Center Point, TXN3612PGoundry George D · Sammamish, WAN3612WKard Aviation LLC · Greenville, SCN36134Manning John W · Floyds Knobs, INN36137Big Bend Community College · Moses Lake, WAN36138Smith Brian Lee · Solvang, CAN36139Flying Sportsmen Inc · Sussex, NJN3613CSchneiderhan Edward F · Laurium, MIN3613NBradbury Kevin Earl · Saint George, UTN3613PLittle Bear Air LLC · Lubbock, TXN3613UN3613u LLC · Lakeland, FLN3613WTurner Travis · Chetek, WIN36141Averill Terry B · Litchfield, MEN36149Gilbert Paul · Diamondhead, MSN3614QMay Robert L · Spring Branch, TXN3614RKrautschun Bart · Spearfish, SDN3614UT Yowonske Enterprises LLC · Rostraver Township, PA
Back to AD 2007-04-19 R1