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.
N181RAPinkowski Richard · Marcellus, NYN181REJacobsen Gary J · Yelm, WAN181RJUaa International Inc · La Verne, CAN181SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN181SBDanclovic Paul D · Freeport, FLN181SCAlpha Charlie Aviation LLC · Oregon City, ORN181TBVector Aviation LLC · Mentor, OHN181TCDezendorf Thomas C · Petaluma, CAN181TKAnderson Brad A · Rochester, MNN181TMEichhorn Scott William · Searcy, ARN181TSJls Aviation LLC · Sarasota, FLN181TWTom Wood Aviation Inc · Fishers, INN181WFNorton Thomas W · Dayton, NVN181WGFlycasual LLC · Bloomington, ILN181WMWozniak David D · Greenfield, MAN181YTailwinds Aviation Academy LLC · Grass Valley, CAN1820EAtp Aircraft 6 LLC · Wilmington, DEN1820TCallender Richard · Presque Isle, WIN18218All Spark Aviation LLC · Naples, FLN1821BBonney Andrew · Marion, MAFirst renewal noticeN1821ZTubbs George L · Colby, KSN18226Filler Joseph J · Wyoming, PAN1822HAdvanced Aviation Group LLC · Frederick, MDN1822XRegistered aircraftN1823EAtp Aircraft 6 LLC · Wilmington, DEN1824HAthar Glenola LLC · Mars, PAN1824JCb Flying LLC · Fulton, MON1824RKleissas Constantine · Wye Mills, MDN18251Rushing Daniel W III · Inlet Beach, FLN1825EAtp Aircraft 6 LLC · Wilmington, DEN1825JAction Interests Inc · Southlake, TXN18260Atc Trucking Inc · Miami, FLN1826TBas Part Sales LLC · Greeley, CON1827AShmily Aviation LLC · Tampa, FLN1827TSilverton Financial LLC · Wilmington, DEN1828EAtp Aircraft 6 LLC · Wilmington, DEN1828MCampbell Larry Lance · White Lake, MIN182ABFoyhwg Inc · Holbrook, NYN182AJN182aj LLC · Hamilton, MTN182AMScavella George A Jr · Hauppauge, NYN182AXN182ax LLC · Newark, DEN182BESimmons Charles · Cora, WYN182BLMccaan Jerome · Bethel, MEN182BZBaker John J · Tucson, AZN182CKDowning Richard C · Arlington, TXN182CWFernandez Miguel A · Merritt Island, FLN182DLehrman Ronald L · Brownsburg, INN182DCHarrington Gesualdo Clare · Greenwich, CTN182DDGulf Coast Helicopters Inc · Pearland, TXN182DKTonso Antonio · Roseville, CA
Back to AD 2006-10-21