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.
N3101TMission Air LLC · Charlotte, NCN3101WGeorge Jon A · Durango, CON3101YJazzminate Inc · La Mesa, CAN3102CD & D Motors LLC · Georgetown, TXN3102DOsowski Christopher J · Anchorage, AKN3102FWhitfield Timothy D · Fairfield, NCN3102WBonanza Leasing LLC · Versailles, KYN3102ZKerzen Properties LLC · Fayetteville, ARN3103CBay Kelly M Trustee · Glennallen, AKN3103ESpartan Education LLC · Tulsa, OKN3103FJorgensen Bryan K · Kingston, GAN3104Larsen Peter M · Hampshire, TNN3104CFlight Training Aircraft LLC · Wilmington, DEN3104FFlorida Armstron Boring LLC · Coeur D Alene, IDN3104QSauer Jason DBA · Glen Ullin, NDN3104TBrobst David D · Durango, CON3104UNelson Christopher · Crown Point, INN3105DHenderson Raymond N · Kosciusko, MSN3105SMorgan A Douglas · Madera, CAN3105TColburn Lant R · Cleburne, TXN3105WDavis Kenneth D · Ft Wayne, INN3105YOakley James H · Spring Valley, CAN3106CPetrie Michael · Chugiak, AKN3106DSouth Delta Aviation Inc · West Helena, ARN3106QStiens Fred T · Moses Lake, WAN3106UPlattinum Leasing LLC · Smoot, WYN31074Hale Aviation Inc · Saint Augustine, FLN31075Camden Group Inc · Boston, MAN31078Walker Richard J · Wasilla, AKN3107FPage Gordie R II · St George, UTN3107PRonald Waldron · Strongsville, OHN3107QWest Valley Aviation Inc · Five Points, CAN3107TRichardson Kroy · Littleton, CON3107URegistered aircraftN3107YSturgill Ricky G · Yucca Valley, CAN3107ZBauer Dereck R · Springfield, ORN31082Bershire Aviation Enterprises LLC · Great Barrington, MAN31084Hannah Bruce A · Anchorage, AKN31087Lvr Air Inc · East Hartford, CTN3108DOchsenbauer David J · Ashland, WIN3108LWickersham Brian L · Council Bluffs, IAN3108NBartlett Paul H · Nebo, NCN3108QSipe Thomas L · Rhome, TXN3108RCocklebur Inc · Sidon, MSN3108SLac Avionics Inc · San Jose, CAN3108ZRinehart John M · Shelbyville, INN3109CVicjen LLC · Bloomington, ILN3109FHeligray LLC · Kalispell, MTN3109PSoft Works Systems Inc · Jamesville, NYN3109QWellink Jos · Katy, TX
Back to AD 2007-04-19 R1