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.
N4603JAll American Aviation Services Inc · Fayetteville, NCN4603MAshley Don E · Willow, AKN4603RRadcliff Rocky J Sr · Tehachapi, CAN4603VLazy Ta Legend Aircraft LLC · Wilmington, DEN4603XDillon Gregory A · Rancho Cucamonga, CAN46045Rabb Randolph W · El Cajon, CAN46047Loudermilk John A · Nashville, TNN4604AThomas Douglas E · Grove City, PAN4604JTrouth Kevin J · Sulphur, LAN4604NS O W Aviation LLC · Crystal River, FLN4604QBas Part Sales LLC · Greeley, CON4604WPlotkin Terry M · Colorado Springs, CON4604XDelaware Aircraft Trust LLC Trustee · New Castle, DEN46050Sentinel Services Group LLC · Brooksville, FLN46054Cabirdassou Meena · Arcadia, CAN46057Flight Time Builders Inc · Memphis, TNN4605FSterling Aviation2 Lllc · Boca Raton, FLN4605JNichols James M · Duanesburg, NYN4605MJohnson Plane Services LLC · Greenbrier, TNN4605QRichs Air Service · Victoria, KSN4605RFive Eagles Group LLC · Pompano Beach, FLN4605UAir Dusters Inc · Roggen, CON46060Registration Pending · Factoryville, PARegistration pendingN46063Low Thomas A Trustee · Derry, NHN4606JKantor Robert James · Rancho S Margarita, CAN4606RAiken Pilot Training LLC · Johnston, SCN4606WCornwell Stephen E · Beaumont, TXN4606YAdirondack Soaring Association Inc · Ballston Spa, NYN46072Fly Anytime LLC · Kankakee, ILN46078Parrish Aviation Flight Academy LLC · Southlake, TXN4607JHodgen Robert T III · Lexington, KYN4607MClark Jean F Trustee · North Falmouth, MAN4607QSerrano Lynn A · Casa Grande, AZN4607RBayside Aviators LLC · Union City, CAN4607WWalmer David H · Tualatin, ORN46085Davenport Jimmy J · Hayesville, NCN46087Range Steven V · Greenfield, ILN4608ATriplett Robert J · Cameron, WIN4608FAdvanced Aerospace Consultants Inc · Boynton Beach, FLN4608WWalden Brian S · Mount Vernon, OHN46091Pilot Instructional Center LLC · Kansas City, MON4609MShields David C · Council Bluffs, IAN4609QN4609q LLC · Opa-Locka, FLN4609SN4609s LLC · Verona, WIN4609UJerden Corp · Overland Park, KSN4609WBoling Kyle C · Oak Hill, FLN460AAAlf Ix LLC · Chicago, ILN460ACArizona Skies Aviation LLC · Scottsdale, AZN460CCAmerican Falconry Inc · Dayton, WYN460EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FL
Back to AD 2007-04-19 R1