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.
N3668CN3668c L L C · Depauw, INN3668DLkj Holdings LLC · Amarillo, TXN3668KPiston Aviation LLC · Saint Charles, MON3668QPaul B Meadowbrook Pc · Albany, ORFirst renewal noticeN3668URedmond John L · Santa Clarita, CAN3668ZYork Matthew J · Waterloo, ILN3669Grasso Vaughn L · Oak Hill, FLN3669NMcdonald Douglas E · Deering, NDN3669QMarshall Jerry W · Centennial, CON3669RFulks Helicopter Service LLC · Norfolk, NEN3669WDocken Marvin O · Omaha, NEN366CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN366CTAia Charlie LLC · Henderson, NVN366DHummer Family Capital Aviation LLC · Boonton, NJN366DMSwaggart Paul Blake · Touchet, WAN366GCHavens Aviation LLC · Blacklick, OHN366HPRey Del Cielo LLC · San Antonio, TXN366KWhite Thomas J · Agua Dulce, CAN366KBThomas William K · Live Oak, FLN366KJBaker Victor R · Carson City, NVN366MATew Services Corp · Wilmington, DEN366MDN366md LLC · Salinas, CAN366METhree Six Six Mike Echo LLC · Mantua, UTN366MKNorth Star Aviation Inc · Mankato, MNN366NHState Of New Hampshire Dept Of Safety · Concord, NHN366PSkyway Unlimited Inc · New London, NCN366PAPureflight Aviation Training LLC · Newberg, ORN366PSA-Team Family LLC · Ashland, ORN366PWEuroaviation Inc Trustee · KematenN366RAdema Walker · Enid, OKN366SGibbs John M · Monterey, CAN366STN366st LLC · Kenesaw, GAN366TBLouie Co Pilot LLC · Liberty Lake, WAN366XRomano Stephen Henry Daniel · Seattle, WAN366ZMendel Carl · Port Charlotte, FLN36700Archuleta Jeffrey Michael · Abilene, TXN3670EFresh-Pic Harvest Inc · La Quinta, CAN3670NMcmanigle Jeffrey M · Osakis, MNN3670RPecht Brian J · Lewistown, PAN3670UHoffman Kevin · Chatsworth, GAN3670XDoerhoff Daniel L Trustee · Lone Jack, MON3670YRoussin David G · Newville, ALN3670ZFaught Jeffrey R · Bismarck, NDN36711N36711 Piper LLC · Provo, UTN3671CCharlie Aviation LLC · Philpot, KYN3671FHenson Ronald E · Bonita Springs, FLN3671MFigvam LLC · New York, NYN3671RRoberts Charlie E · Cleveland, GAN3671WOdean Steve · Palmer, AKN36724Reeves Richard G · La Verne, CA
Back to AD 2007-04-19 R1