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.
N500EBKaizen Aircraft Holdings LLC · Kalispell, MTN500FTTwin Aviation LLC · Coushatta, LAN500FWWohltman Valerie A Trustee · Effingham, ILN500GDElizondo Ernesto · Laredo, TXN500GEStevenson Anesthesia Associates Pc · Wolfforth, TXN500GGSawtooth Travel Solutions LLC · Twin Falls, IDN500GMSto Cazzo Aviation LLC · Danvers, MAN500GPEhg Flight LLC · Venice, CAN500GSCloud Chaser Aviation LLC · Chesnee, SCN500HKSegerstrom William C · Sunriver, ORN500HTJones Angela K · Lenoir City, TNN500HURower Gary · Brooks, GAN500JAAiken Jasper · Rigby, IDN500JLJet-H Inc · Oak Park, CAN500KBKilo Bravo LLC · Mount Airy, MDN500KCRuiz Edinson · Bakersfield, CAN500KTLincoln Land Airmotive LLC · Springfield, ILN500KWWilson Kenneth E · Hale, MON500LDJ & H Investment Corp Inc · Columbia, MON500LHParis Air Inc · Vero Beach, FLN500LTSeeth Richard D · Yardville, NJN500MBBrown Mark R · Cotter, ARN500NAFive Star Marketing Inc · Raleigh, NCN500NPVolare Air LLC · Palm Harbor, FLN500PFord Charles D · Clifton, TNN500PFHumphries Stephen A · Kingwood, TXN500PSWing John E · Rowlett, TXN500QBAnderson Dana R · Redding, CAN500QVJands LLC · Broken Arrow, OKN500RCWright Mason · Henderson, NVN500RFJones Anthony Blake · Sylacauga, ALN500RVTaylor Moore Lc · Columbia, MON500SBKostelic Tanner · Alpena, MIN500SGSimplicity Inc · Redmond, ORN500SHMergili Joseph P · El Paso, TXN500TMcconnell Harold L · Cavalier, NDN500TBSky West Aviation Inc Trustee · Albuquerque, NMN500TEGovers Harald · Mesa, AZN500TFPine Bluff Police Department · Pine Bluff, ARN500TLSententia LLC · Highland Park, ILN500TUAlpha Jets USA Inc · Clarksville, TXN500VBParagon Airplane Leasing Co · Fort Myers, FLN500VEGame On Aviation LLC · Charlotte, NCN500WN500w LLC · Ashburn, VAN500WCRickey Donald N · Murfreesboro, TNN500WELawler Glenn M · Mooresville, NCN500WMBim-Merle Robert W III · Piqua, OHN500WPWelker Franklin W · Agoura, CAN500WSKns Asset Management LLC · Lumberton, TXN500YEHill Clifford D · Warsaw, IN
Back to AD 2007-04-19 R1