AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N779JNTorque Aviation Inc · Smithfield, VAN779KSIsland Air Charters Inc · Ft Lauderdale, FLN779KTTurner Keith R · Coupeville, WAN779LKAtmospheric Vehicle & Spacecraft Flt Exploration · Rch Palos Vrd, CAN779PTMacon Air LLC · Franklin, NCN779RVBusby Jorge B · Monroeville, ALN779SATextron Aviation Inc · Wichita, KSN779SHHillsboro Aero Academy LLC · Hillsboro, ORN779WMGoldman Jon L · Smithtown, NYN779XCJensen Michael C · Bainbridge Island, WAN779ZGiarratana Stephen J · Clinton, MSN77AKRivers Paul E · Shannon, ILN77AXWest Jeffrey N · Holladay, UTN77BLLesnett Robert Gage Trustee · Vida, ORN77BWWhitaker Eric · Detroit, TXN77CHTcb Management Inc · Chiefland, FLN77CTHays Cory W · Beaumont, TXN77CVNaikelis Robert · Hampstead, NCN77DDFenger Thomas A · Palmer, AKN77DHBramon Bruce M · Sunrise Beach, MON77DRGeodetic Associates International LLC · Pittstown, NJN77DWTop Flight Detail LLC · Middlebury, INN77EBBowles Alan B · Georgetown, TXN77EKRv 7 77 LLC · Port Saint Lucie, FLN77ERFrech Betty J Trustee · Columbia, MON77FLMeyer Adnrew J · Clear Lake, IAN77FPRegistration Pending · New Richmond, WIRegistration pendingN77FSRoberts Eric · Grayslake, ILN77GParker Ray W · Nome, AKN77GATaliaferro John C · Abilene, TXN77GBSmith Kevin F · Sherman, TXN77GDN77gd LLC · Kalispell, MTN77GGCoben Craig S · Smithville, OHN77GHWagner Rickey J · Stacy, MNN77GLLange Cory J · Blaine, MNN77GMMartin Gustavo E · Cooper City, FLN77GRHubbard Benjamin L · Quogue, NYN77HXAppold Dave J · Bay City, MIN77JCMundwiler David Gary · Hemet, CAN77JGGoon Aviation LLC · Kalispell, MTN77JTDrewry James D · Dayton, TXN77JYPloeger William A · Melbourne, FLN77JZZimmerman James L · Arvada, CON77KFEischens Kolton S · Wasilla, AKN77KHHolcomb Ken C · San Diego, CAN77KSPerkins Carey Alan · Hesperia, CAN77KTRochna Stephen J · Fallon, NVN77LPrice Paul W · St George, UTN77LARaintree Aviation LLC · Mesa, AZN77LFWallace Dustin A · Vacaville, CA
Back to AD 81-18-04 R2