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.
N3330MMaine Instrument Flight · Augusta, MEN3330RJph Incorporated · Kokomo, INN3330UWolford Alyson · Bonney Lake, WAN3330XMylin LLC · Havre De Grace, MDN3330YTighe Joseph E · Kingsland, TXN33313Larson Laurinda P · Hubert, NCN33318Sudweeks Will · Overton, TXN33319Nationwide Aviation LLC · Hudson Oaks, TXN3331DKramer Donald J · Buffalo, MNN3331QEvangelista Ronald · Castle Rock, CON3331REpik Industrial LLC · Terre Haute, INN3332Degaynor Gregory S · Zeeland, MIN33321Lauher Donna · Wimberley, TXN33324Central Nebraska Spinal Surgery Center Pc · Kearney, NEN3332BAirkrapf LLC · Clearwater, FLN3332SFluckey Gary T · Homer, AKN3332TWilliams Darryl L · Medina, OHN3332UMing Greg A · Guymon, OKN3332ZWeisenburger Adam A · Seeley Lake, MTN33338Graham Mark · Fort Smith, ARN3333MFun Tickets LLC · Manchester, MEN3333RBuck Joseph M · Copper Center, AKN3333WRegistered aircraftN3333YDeville Charles D · Clinton, LAN33348Air Venture Inc · Hagerstown, MDN33349Stroud Jerry · Hope, ARN3334EJarmer Ryan F Trustee · San Diego, CAN3334PM & M Aero LLC · Wilmington, DEN3334QViking Aerial Photography LLC · Zionsville, INN3334TBaumann Keith A · Fairfield, ILN3334YHarless Richard K · Battle Mountain, NVN3335BHutsell James M · Miamisburg, OHN3335DWilson Zane D · Fairbanks, AKN3335FSocorro Meraz · El Paso, TXN3335PHill Silas W Trustee · Delta Junction, AKN3335RJones Wesley M Jr · Hollywood, SCN3335UFogle Kenneth J · Chagrin Falls, OHN3335XPfeiffer Engineering LLC · Boonville, MON33361Petit Raymond T Trustee · Westerville, OHN33363Mcdonald Joseph W · Olympia, WAN33367Smtm Holdings Inc · Wilmington, DEN3336MStevens Matthew Joel · Millersburg, MIN3336SVancil Todd · Justin, TXN3336TBirch Point Ventures LLC · Virginia, MNN3336WBuck Brothers · Joliet, ILN3336ZCedar Mark P · Cherokee, IAN3337Chay James M · Kent, WAN33371Galle David R Trustee · Manchester, NHN33372N33372 LLC · New Bern, NCN33376Price Gregory D · Frankfort, IL
Back to AD 2007-04-19 R1