AD 2007-06-07
Registered aircraft · 1,100
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-06-07')
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-06-07')
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-06-07') 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-06-07') 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.
N1604WSteve Byrd Aviation LLC · Terrell, TXN1629WRegistered aircraftN-number assigned, not yet registeredN1648WKings Aviation Corp · Garden City, NYN164MDehaan David J · San Diego, CAN166BVSensing Aviation LLC · Nashville, TNN1673WOci Ltd · Brunswick, GAN167TRBarton Aviation LLC · San Antonio, TXN168CCLanham Aviation LLC · Simpsonville, KYN169LALee Arnold Management Services Inc · Clearwater, FLN169RRGerlach & Associates LLC · Valparaiso, INN16BKWc Aviation LLC · Forest, VAN16DADonaire Aviation LLC · Tampa, FLN16PMcmurray Justin John · Durham, NCN16PVAlign Aviation LLC · The Woodlands, TXN1710ABald Mtn LLC · Modesto, CAN172DHSanta Lucia 930 LLC · Greenwich, CTN174URocky Mountain Ventures Inc · Cheyenne, WYN1756SRed Rocket LLC · Greenville, NCN17660Simpson Chad · Harrison, ARN176RKY-12 Investments LLC · Alexandria, VAN17833Mccall Edmund B · Portland, ORN17979Alford Flying LLC · Wichita, KSN17980Rowles Robert · Pittsfield, ILN17BRJds Management Co LLC · Warner Robins, GAN1807NDouble Barrel Aviation LLC · Fort Valley, GAN1810XAviation Trust Company LLC Trustee · Oklahoma City, OKN18142Aviation Trust Co LLC · Oklahoma City, OKN1817SClear Skies LLC · Stuart, FLN1827LCone James R Jr · Lubbock, TXN18296Star Flight Aviation Inc · Shreveport, LAN1829ECorporate Airtime LLC · Clinton, MSN18320Cox Jack H Jr · Arlington, TXN18351Iowa Great Lakes Flyers Ltd · Cheyenne, WYN18358Life Is A Beech LLC · Los Lunas, NMFirst renewal noticeN18361Landvater Darryl V · Williston, VTN18364Goeken Peter C · Dakota Dunes, SDN18386Gamco Aviation LLC · Shreveport, LAN18475Gerlach And Associates LLC · Valparaiso, INN1852WDavis Sean · Carlisle, IAN1854RSellers William G III · Troy, ALN185ARortvedt Robert S · Mukwonago, WIN186VBLatb LLC · Lewes, DEN18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILN18752Morgantown Flying Club LLC · Morgantown, WVN1889WSabre 65 LLC · Helena, MTN1895LPalm Group LLC · Metairie, LAN18HMYoung Craig · Ada, MIN18VRVentura Air LLC · Wilmington, DEN1901LBerry Darrel · Camden, TNN190RSBas Part Sales LLC · Greeley, CO
Back to AD 2007-06-07