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.
N166GAerospace Trust Management LLC Trustee · Wilmington, DEN166JKKoon James A · Fortson, GAN166JPBaby Bird Aviation LLC · Sarasota, FLN166JRLinebaugh Jeffrey A · Port Orange, FLN166LHFarmingdale State College · Farmingdale, NYN166LMFlight Rt LLC · Thonotosassa, FLN166NGVaught Timothy A · Mauldin, SCN166PTTurnbull Clayton · Kamuela, HIN166RVYoungdahl Thomas P · Mendota Heights, MNN166RWGrasshopper Aviation LLC · Betsy Layne, KYN166TCCaple William Henry Jr · Chandler, AZN1671BEwing Willard Paul · Becker, MNN1671CCe-172 Aircraft LLC · Wilmington, DEN1672CCe-172 Aircraft LLC · Wilmington, DEN1672RBriggs Donald L · Santa Barbara, CAN1673CCe-172 Aircraft LLC · Wilmington, DEN1673RGregory John F · Emmitsburg, MDN1674EMedary Aviation LLC · Brookings, SDN1676CCe-172 Aircraft LLC · Wilmington, DEN1676RBlue Side Up LLC · Elbert, CON16789Smith Stephen · Annandale, VAN1678CCe-172 Aircraft LLC · Wilmington, DEN1678HBrown Gregory B · New London, CTN167BHHolliday Robert R · Andover, KSN167BWMartin Jennifer · Palm Desert, CAN167CPCivil Air Patrol · Maxwell Afb, ALN167CSBalister Adrian G · Colorado Springs, CON167CWNorinsky David · Petaluma, CAN167LDRegistered aircraftN167LPSymanowski Kevin L · Reeder, NDN167QQGrondahl Chad R · Peyton, CON167SDierenfeldt William Travis · Manhattan, KSN167SUSouthern Utah University · Cedar City, UTN167UDLima 001 LLC · Muscatine, IAN1680RSchulze Roger F · Hanford, CAN1682RDelcamp Don D · Troy, OHN1683CCe-172 Aircraft LLC · Wilmington, DEN1685Lane Aviation LLC · Tijeras, NMN1687CCe-172 Aircraft LLC · Wilmington, DEN1688CAerosim Academy Inc · Sanford, FLN1688LHeavy Metal Air LLC · Farmingdale, NYN16894Saz Dynamics LLC · Daly City, CAN16895Luxair LLC · College Station, TXN168AAWest Elk Capital LLC · Niwot, CON168ALWittman Matthew · New York, NYN168AVAce Helicopters LLC · Colfax, WIN168BCWildlife Air LLC · Dubois, WYN168BLWingsleasing LLC · Wichita, KSN168CACivil Air Patrol · Maxwell Afb, ALN168CBLogan Air Services LLC · Logan, UT
Back to AD 2006-10-21