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.
N274AMMc Communications LLC · Conway, ARN274BBLcb Leasing · Manassas, VAFirst renewal noticeN274CDAloha Helicopter Tours LLC · Lihue, HIN274CTGoodwin Roger I · Palm Coast, FLN274CWWilson Chuck W · Mckinney, TXN274DCMaggie 288 LLC · Quincy, WAN274DMGustafson James R · Granby, MAN274ERFlying Vikings Inc · Hayward, CAFirst renewal noticeN274GPlunkett Carlton C · Terry, MSN274GBM And G Brown LLC · Independence, ORN274GTSkogen Joseph S · Coeur D Alene, IDN274HAPacific Rain Inc · Arroyo Grande, CAN274HSWebb Alan J · Medford, ORN274JFerris John A · Priest River, IDN274JP802 21st Street LLC · Paso Robles, CAN274JZAcv Group LLC · Mckinleyville, CAN274LCHuismann Lucas A · Whitehall, WIN274LECsonka Bela · Hesperia, CAN274LSBmk Farms · Fowler, KSN274MAHot Wings Aviation LLC · Fishers, INN274MDDickenson Bruce E Trustee · Santa Paula, CAN274MESabra Davis Corp · Wilmington, DEN274MMHanzawa George DBA · Wahiawa, HIN274MRAero Systems Inc · Broomfield, CON274SScott Joseph Brian · Sarasota, FLN274SLHowden Frederick M · Coronado, CAN274TLussier Ian · Owls Head, MEN274TEBas Part Sales LLC · Greeley, CON274VFSkylane Victor Foxtrot LLC · Annapolis, MDN274VWBonanza Parts Inc · Davis, CAN274WEShenton John J · New Harbor, MEN274ZAlpha Tango Aircraft LLC · Wilmington, DEN2750MMcgibbon Aviation LLC · Denver, CON2750PHill Kevin M II · Dudley, MAN2750WVance John · Coleman, TXN2751Junkins Brent · Killen, ALN2751FAzuris & Co · Albuquerque, NMN2751GSpears Patricia C · Longmont, CON2751PSmith Kevin L · Peachtree City, GAN2751QValu Prop LLC · Fargo, NDN2752FSchoppaul David · Anthem, AZFirst renewal noticeN2752GZambarano Matthew C · South Hero, VTN2752PAnderson Aerial Spraying Service Inc · Canby, MNN2752QAnspaugh Bruce E Trustee · La Crescenta, CAN2752WL Deckard Aviation Ministries · Waller, TXN27532Shadow Aviation Inc · Fairbanks, AKN2753AThomas Dale A · Gooding, IDN2753CChapman Grant W · Wasilla, AKN2753GJans Dream Machine LLC · Lewes, DEN2753QFull Throttle Aviation LLC · Terlingua, TX
Back to AD 2007-04-19 R1