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.
N3601YFirst Cut Excavation LLC · Hamilton, MTN3601ZMid Atlantic Air Museum · Reading, PAN36024Walla Walla University · College Place, WAN36028Armstrong Robert Reno · Lakin, KSN3602KHoulton International Flying Club · Houlton, MEN3602MReinath Michael S · Rio Vista, CAN3602UBritsch Michael J · Anchorage, AKN3602WJeswald Joseph M · Buffalo, NYN3602YMissionary Aviation Repair Center · Soldotna, AKN36031Markey William C Trustee · Wenatchee, WAN36035Hilstad Steve D · Mayville, NDN3603HLewis Paul Jr · West Chester, PAN3603QWray Development Inc · Menifee, CAN3603YCarter Duane Lee · Madison, GAN3604CCosby Asa L · Weldon, CAN3604HDobbelaere Bros Inc · Oakwood, OHN3604KQureini Khalil H · Strongsville, OHN3604LWalker Carol L · Ennis, TXN3604PRegistration Pending · League City, TXRegistration pendingN3604XJones Bryan David Kingsley · San Diego, CAN36052Icarus Flying Academy LLC · Farmingdale, NYN36056Cleared Aviation LLC · Novato, CAN3605CChambers Joseph B · Oswego, NYN3605HChilders Matthew W · Scottsdale, AZN3605PSmith Bryan · Wenatchee, WAN3605YVita Clean Services · Wenatchee, WAN3606CHendrix Grant Mcmahill · University Place, WAN3606EMiller Robert J · Casselton, NDN3606MStuart B Stephens Dds Ms Plc · Yukon, OKN3606ZLandreth Homer W · Peoria, AZN36071Aero Systems Consultants Inc · Tulsa, OKN36077Coffey Diane L · Chuckey, TNN3607DCusick Christopher J · La Jolla, CAN3607EPalm Cedric C · St Francisville, LAN3607QToole William Barry · Goochland, VAN3607UHastings Flyers LLC · Hastings, NEN3607WOceanstate Flying Club Inc · Little Compton, RIN3607XAldrich Roy · Webster, SDN3607YHlavnicka Timothy D · Haines, AKN3608MRoman Peter A · Aurora, ILN3608URegistration Pending · Homer, AKRegistration pendingN3608WHand Andy A · Waco, TXN3608ZBingman William A · Depoe Bay, ORN36094Jupiter Flight Service And Investing LLC · Lithonia, GAN36095Wiese Robert M · Washburn, NDN36096Miami Arrow LLC · Peru, INN3609EBismarck Aero Center Corp · Bismarck, NDN3609MKosbruk Patrick E · Perryville, AKN3609WConverse James Robert · Port Saint Lucie, FLN3609ZVeal Petra L · Sterling, AK
Back to AD 2007-04-19 R1