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.
N5074PShingledecker Robert K II · Ozark, ARN5074TPate Michael G · Pontotoc, MSN5074WWells Byron R · Bunn, NCN5074XBaker Jim · Hermosa, SDN5075SWhitlock Holdings LLC · Honey Grove, TXN5075VSanders Jodie D · Fort Worth, TXN5075WBores Scott J · Huron, OHN5075YAlkota Of Kansas LLC · Wichita, KSN50762Skyhawk Group · Kent, WAN5076EJensen Adam G · Anchorage, AKN5076RStable Approach Aviation LLC · Vestavia, ALN5076TDriffill Leroy R · Antonito, CON5076XPalmer Bryce P · Chugiak, AKN50771Flying Mermaid LLC · Aiea, HIN50772Donnelly Jennifer A · Hackettstown, NJN5077DPrentiss Zachary Callan · Grand Junction, CON5077EWest Elk Air LLC · Gunnison, CON5077JVander Dussen Jonathan E · Clovis, NMN5077RHawkins Transportation LLC · Anchorage, AKN5077TBerg Sanford B · Lakeville, MNN5077VAdams Ron · Lovell, WYN5077WSkyport Aviation LLC · Birmingham, IAN5077XLussier John A · Greene, RIN50780Beech Beauty LLC · Broomfield, CON5078BWallace Wayne P · Graham, WAN5078MHolcomb Chris · Amarillo, TXN5078PPutnam Andrew L · New Limerick, MEN5078RBlue Goose Aviation Inc · Polson, MTN5079AHeaton Tykus · Malta, IDN5079YDiaz Apolo · Kansas City, MON507AFAmeriflyers Of Texas Inc · Addison, TXN507DGLynn John Earl Jr · Anchorage, AKN507DMChristiansen Aviation LLC · Wilmington, DEN507DROrtega Aviation Services LLC · Wichita, KSN507DTThomas Mark R · Clintondale, NYN507EFFreitag Ernst · Concord, CAN507EREmbry-Riddle Aeronautical University Inc · Prescott, AZN507FH 507 LLC · Austin, TXN507FLSpence Ryan · Chicopee, MAN507GCareer Pilot Training LLC · Wilmington, DEN507GBCountry Cabinet Shop Inc · Benton, KSFirst renewal noticeN507GLSky West Aviation Inc Trustee · Albuquerque, NMN507HHunt Jack A · Cumming, GAN507HHGrossetete Nugget S · Edgewood, NMN507HSSilvestro Santo · New Canaan, CTN507JLLara Jess D · Albuquerque, NMN507JMMagdaleno Joseph M II · Reno, NVN507JPShrike Comm LLC · Matthews, NCN507LAColumbia Leasing LLC · Hillsboro, ORN507LSLansing Community College · Mason, MI
Back to AD 2007-04-19 R1