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.
N4811GPoplar Grove Airmotive Inc · Poplar Grove, ILN4811JSeals Kenneth P · Munford, ALN4811NMiller Edwin C · Proctor, WVN4811USwartz Ryan W · Pierre, SDN4811YSale Reported · Dover, DESale reportedN4812CRennekamp Eric J · Andersonville, TNN4812FNorth American Aerial Surveys LLC · Tucson, AZN4812JJohnson Chris A · Fort Mohave, AZN4812LPalmer Xavier · Moreno Valley, CAN4812SEdwards Daniel M · Wendell, NCN4812TBas Part Sales LLC · Greeley, CON4812UFoster Frank Brian · Goldsboro, NCN4812YRc Ag Air LLC · Cairo, MON48130Estes Johnny C · Senoia, GAN4813AVon Etten Robert P · Ravena, NYN4813CCivil Air Patrol · Maxwell Afb, ALN4813GBasso Michele · Millbrook, ALN4813LFitzgerald Timothy R · San Antonio, TXN4813MCouch Walter J · Patterson, LAN4813P4813p LLC · Newport, MEN4813SWescomp LLC · Kissimmee, FLN4814Crawford Benjamin D · Anchorage, AKN4814CKingsky Flight Academy LLC · Lakeland, FLN4814DAir Puerto Rico Corp · Aguadilla, PRN4814LSingh Manjinder · Houston, TXN4814SRegistered aircraftN4814TRobertson Roland L · Meridian, IDN4814UHash Marshall T · Inglis, FLN4814YKnerr Joshua D DBA · Tehachapi, CAN4815Ober John A · Candor, NYN4815BCochise Community College · Douglas, AZN4815CSt Pete Aviation Services LLC · Saint Petersburg, FLN4815DBodeen Lance A · Eagle River, AKN4815FAir 2 Sea LLC · Martin, TNN4815JRise Ronald B Jr · Purcellville, VAN4815LSt Julian Randall R · Botkins, OHN4815TCrosswind Aviation Of Oklahoma LLC · Stillwater, OKN4815YAdrian Soaring Club Inc · Ypsilanti, MIN4816ASullivan Phillip M · Louisville, KYN4816JMorten Derek J · Northwood, NDN4816LGodfrey John E · Greensboro, NCN4816RA&C Ag Aviation Inc · Unadilla, GAN4816SYarbrough Clay Alan · Brownsboro, ALN4816TBulldog Air LLC · Wilmington, DEN4816VCollins Lisa A · Lake Dallas, TXN4817DWirt James · Goldsby, OKN4817TJoly Paul A · Henderson, NVN4817YQuality Aviation Inc · Marana, AZN48187Nelson Lynn D · New Waverly, TXN4818ACampbell Allen G · Sault Sainte Marie, MI
Back to AD 2007-04-19 R1