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.
N3181SWood David M · Purcellville, VAN3181TDuck Donald S · Edwardsburg, MIN3181UBig Sky Aviation LLC · Ridgeland, MSN3181WNormark Jordan C · Granbury, TXN3182DHanft Thomas A · Oakhurst, CAN3182LN303cj LLC #1 · Lexington, KYN3182QMagnusson Ralph L · Wyoming, MNN3182RSeven Hills Sky Divers Inc · Madison, WIN3182SRyan Aviation Management LLC · Palm Coast, FLN3182UGarcia-Martinez Jose Victor · Birmingham, ALN3182WOutstate Air Taxi Inc · Windom, MNN3182YHeckethorn Philipp · Baker, NVN3182ZArnt Aerial Spraying Inc · Worthington, MNN31831Dcoat LLC · Greenlawn, NYN3183CWide Open Aviation LLC · Kennewick, WAN3183DT2k Aircraft · Austin, TXN3183L4 All In Inc · North Fort Myers, FLN3183QMj Syndicate LLC · Vancouver, WAN3183RRusso Anthony G · Melbourne Beach, FLN3183SJohnson Richard · Winnebago, MNN3183YAlc Aviation LLC · Milwaukee, WIN3183ZPancoast John M · Palmer, AKN31841Rotormate LLC · Royse City, TXN3184DRitchie Rex W · Lopez Island, WAN3184LKimbrell Heath · Quinlan, TXN3184QBeaugh Anthony H · Platteville, CON3184RGardner Daniel J · Alvord, TXN3184SThrash Farms Inc · Pelahatchie, MSN3184TMetroplex Flight Services LLC · Fort Worth, TXN3184YFunkhouser David E · Weatherford, OKN3185CThree Pipers Piping LLC · Charleston, SCN3185DMorgan Douglas C · Anchorage, AKN3185F85 Foxtrot LLC · Redmond, ORN3185QPara Tactics LLC · Shelton, WAN3185YGochenour Air Inc · Fort Wayne, INN3186Shettel Jay E II · Carlisle, PAN31863Dell Air Co LLC · Paterson, NJN31865Hartwig Flying Service LLC · Eagle River, WIN31868Yarger Dylan C · Anchorage, AKN3186DSutton Aircraft Salvage LLC · Palmer, AKN3186QKimbril Steve · Hartselle, ALN3186RHuey Gale R · Celeste, TXN3186YJram Air Parts LLC · Henderson, NVN31871Dodson Randall L · New Hope, MNN3187CHemm Colby L · Newcastle, CAN3187FVolatile Aero Ventures LLC · Boulder City, NVN3187HDike Randall K · Owensville, INN3187PAir Over Ground LLC · Helena, MTN3187QJuliet Whiskey Aviation LLC · Gilbert, AZN3187SWinberg Tanner · Dorchester, NE
Back to AD 2007-04-19 R1