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.
N517SWStarship Aviation LLC · Northville, MIN517TPAerotrust Services Corp Trustee · Wilmington, DEN517VBBoudro Vernon G · Greenview, CAN517WCFreedom Wings LLC · Parker, CON517WDAmundson Lee R · Chatfield, MNN5180Allen Michael G H · Casper, WYN51804Summit Aviation Inc · Belgrade, MTN5180EMission Aviation Training Academy · Arlington, WAN5180LGrogan Timothy · Bradenton, FLN5180PN5180p LLC · Willow Springs, MON5180RMacdonald Kaitlyn · Dillon, MTN5180UAssociation Of Baptists For World Evangelism Inc · Harrisburg, PAN5180XSouthern Sky Holdings LLC · Macon, GAN51810Jones David L · Powderly, TXN51816Barr Air Patrol LLC · Mesquite, TXN5181DSchrick Robert B · Firth, NEN5181EMustang Sally Aviation LLC · Camden, SCN5181GWalton Daniel G · Troy, MON5181HRegistered aircraftN5181JForce One Inc · Missoula, MTN5181NValiair Lc Trustee · Casper, WYN5181PFritz Joseph L · Eufaula, OKN5181REdelen Daniel R · Clayton, NCN5181SHicks Douglas A · Cumming, GAN5181WSzymanski Janet M · Alanson, MIN5181XKummer Nicolas · Wenatchee, WAN51826Van Dyke James C · Pleasant Grove, CAN51827B D Aviation LLC · Sauget, ILN5182DJensen Rodney H · South Jordan, UTN5182ERegistered aircraftN5182GWeese C · Quinlan, TXN5182HVanderpool Robert W · Red Devil, AKN5182JEmery & Associates Inc · Orangeville, PAFirst renewal noticeN5182LGarden City Aviation LLC · Augusta, GAN5182PThede Dondi I · Marshall, WIN5182RHalf Wagon Innovations LLC · Cresson, TXN5182SFoster Tyler R · Levelland, TXN5183LWolstenholme Robert F · Line Lexington, PAN5183MGc Aviation Services 1 LLC · Miamisburg, OHN5183RThompson Aerial Service Inc · Wyndmere, NDN5183SWestland Aviation LLC · Lake Havasu City, AZN5183TMinier Tryg · Corralitos, CAN5183WG S I Training Services Inc · Branson, MON5183XStory James W · Byhalia, MSN51840Sky Bubble LLC · Santa Ana, CAN5184EStringfellow Timothy C · Maryville, TNN5184GSicking Ryan · Gainesville, TXN5184JRiverside Flight Academy LLC · Riverside, CAN5184LOtt Timothy M · Ida, MIN5184PBarr Air Patrol LLC · Mesquite, TX
Back to AD 2007-04-19 R1