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.
N738SPOur Jett LLC · Englewood, CON738SRRise Aviation LLC · Auburn, ALN738SSFalcon Aire LLC · Mequon, WIN738STBergstrom Aircraft Inc · Pasco, WAN738SUNab Aviation Holdings LLC · Cocoa Beach, FLN738SYVan Anda Aviation LLC · Apopka, FLN738TBSorbi Aviation Inc · El Cajon, CAN738TFFly Vector LLC · Spring Hill, FLN738TGWings Aero LLC · Zeeland, MIN738TJGlendale Community College · Glendale, CAN738TMBrown Clifford · League City, TXN738TNBarnett Mary C · Upland, CAN738TPLacey Christopher · Cape Coral, FLN738TQLake Travis Flyers LLC · Granite Shoals, TXN738TTRfc Inc · Hiawatha, IAN738TVGordon Benny B · Columbia City, INFirst renewal noticeN738TXLavalley Asset Management Inc · Potsdam, NYN738TZRegistration Pending · Fort Worth, TXRegistration pendingN738UDAffection Above Aviation Inc · Yukon, OKN738UESteinkamp Loren L · Fairmont, MNN738UHSale Reported · Calabasas, CASale reportedN738URCooper William J Jr · Littleton, NCN738UTWright Flyer LLC · Palm Coast, FLN738UUCiuccio Louis V · Old Forge, PAN738UWAircraft Management Services Inc · Milton, FLN738UYOptima Aviation LLC DBA · Lewisville, TXN738VAFive Rivers Flight Training LLC · Livermore, CAN738VBBrafa Frank T · Leesville, LAN738VCMarlin Walter E II · Locust Grove, GAN738VGTepper Steven · Freehold, NJN738VJCommand-Aire LLC · Seattle, WAN738VLBasler Leon E · Sainte Genevieve, MON738VRWoodward Tyler James · Norman, OKN738VTStrutin Millard Desmond · Hackettstown, NJN738VUFive Rivers Flight Training LLC · Livermore, CAN738VVPureflight Aviation Training LLC · Newberg, ORN738VWAwnf LLC · Burleson, TXN738VYRpm Aero LLC · Lincolnwood, ILN738WCBrb Grand-Air LLC · Indiantown, FLN738WEBray Aviation LLC · Calera, OKN738WGZlock David · Lakeville, MNN738WHPiraino Philip A · Middletown, DEN738WJSpann Leonard D · Little Rock, ARN738WKMallette Christopher Lee · Saint Rose, LAN738WLBrenair Inc · Mcalester, OKN738WMMayers Trevor D · Miami, FLN738WNSkywarrior Flight Training LLC · Pensacola, FLN738WRRoberts Dwight C · Seminole, OKN738WVJohnston John A · Raleigh, NCN738WYIsland Aircraft LLC · Anchorage, AKFirst renewal notice
Back to AD 81-18-04 R2