AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N15694Registered aircraftN15695Baldwin Lydia H · Fort Collins, CON15696Truair LLC · Chaska, MNN1569XStroud Jerry L · Hope, ARN156AADardis Aviation LLC · Alpine, WYN156DCEaton Billy J · Bridgeport, TXN156DMDeleonrdis Donato · Paulden, AZN156DSFanoe Nicholas J · Salinas, CAN156HRCallahan Bryan J · Apalachicola, FLN156LGAirsign Airships America LLC · Williston, FLN156MAMedia Exp LLC · Portland, ORN156MEArcher III LLC · Littleton, CON156PSSkywest Leasing Inc · St George, UTN156RMMarek Robert C · Cadott, WIN156SHSpitzer Helicopter LLC · Woodland Hills, CAN156WMFixed Wing Holding Company Inc · Pembroke Pines, FLN156XN156x LLC · Fayetteville, GAN15703Schubert Brothers Aviation Inc · Canandaigua, NYFirst renewal noticeN15707Brennan Christopher S · Newark, DEN15708Lanza Thomas N · Las Vegas, NVN15709Avioelectronica Inc · Sunrise, FLN1570RHall Clarence W Jr · Fayetteville, ARN15725Hassell Dan J · Ketchikan, AKN1572EKorkmaz Fethi A · Asheville, NCN1572RBurke Kenneth L · Colleyville, TXN15731Parsons Allen L · Marriottsville, MDN15734Wayland Flyboys LLC · Wayland, IAN15735235 Aviation LLC · New Smyrna Beach, FLN15739Flymart Inc · Hastings, FLN1573RGrand Scott LLC · Okemos, MIN15744West Kentucky Flyers Corp · Murray, KYN1574XQuinones Roland · Plano, TXN15757Dickinson Ross · Tilden, TXN1575RSpurlock Daniel C · Harrogate, TNN1575VMissouri Reliability Services LLC · Maryville, MON1575XMaring Thomas J · Westley, CAN15763First Pryority Bank · Pryor, OKN15764Leyva Jose Luis · New Smyrna Beach, FLN15765Moulder Tyler Dane · Huntsville, ALN15776Rc & C Inc · Norwalk, IAN1577ESeibert Lynn K · Fresno, CAN1577RGlobal Aircraft Trust Inc Trustee · Cheyenne, WYN15782Crane Austin · Redlands, CAN15783Pretorius Anthony · Easley, SCN15788Chafin Gerald III · Mountain Home, ARN15789Sidc2 LLC · North East, MDN1579RSkelton James P Jr · Lithia Springs, GAN1579TPedro Christopher M · Dushore, PAN1579XBuchberger Robert J · Plainfield, WIN157AMPhotofax Inc · Gilberts, ILFirst renewal notice
Back to AD 2006-10-21