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.
N739WXAce Of Spades Aviation LLC · Las Vegas, NVN739WYN739wy LLC · Cheyenne, WYN739WZWhisky Zulu Inc · Port Washington, NYFirst renewal noticeN739XA7550g LLC · Birmingham, MIN739XCAllen Danny T · Jonesboro, LAN739XKAirways Aviation Inc · Grand Rapids, MNN739XLFlyrjf LLC · Weirsdale, FLN739XMEnstad Ordell J · Goldendale, WAN739XSGorman Patrick M · Deerfield, OHN739XTS O W Aviation LLC · Crystal River, FLN739XUTraining Mission Aviation Inc · New Tripoli, PAN739XVAmaro Mark S · Mi Wuk Village, CAN739XWWhole Life Wellness Center · Alpine, TXN739YESundance Air Services Inc · Alameda, CAN739YHMelbourne Flight Training LLC · Melbourne, FLN739YMHeritage Aviation LLC · Ankeny, IAN739YRF&O Flight LLC · Calhoun, GAN739YURrrr Aviation LLC · Bryan, TXN739YWPettit Toby B · Morehead, KYN739YZSocal Aviation Inc · Chino, CAN739ZCP&B Aviation LLC · Watkins, CON739ZGR & R Aero Services Llcc · Eden Prairie, MNN739ZHFreeflight Aviation LLC · Allentown, NJN739ZLLefebvre Jeffrey S · Kaneohe, HIN739ZNOur Jett LLC · Englewood, CON739ZPBlue Sky Aviation LLC · Watkins, CON739ZRJw Horton Aviation LLC · Rogers, ARN739ZSPryor James A · Bottineau, NDN739ZUMelbourne Flight Training LLC · Melbourne, FLN739ZWHolladay Aviation LLC · Jacksonville, FLN739ZXN739zx Flying Association · Kent, WAN739ZZR & R Aero Services LLC · Eden Prairie, MNN73AGHarrison Albon Wayne Jr · Lake Jackson, TXN73ALHefel Lori A · Wichita, KSN73AXJensen Steven · Port Angeles, WAN73BCVnk Sky Inc · Dover, DEN73BWBravo Whiskey Holdings LLC · Lewis Center, OHN73BYRivas Taylor · Olympia, WAN73CHAb Prop Plane II LLC · Metairie, LAN73CMMau Christine A · Niceville, FLN73CPQuality Concrete LLC · Brentwood, TNN73CVLiberatore A H Bud · Eagle Point, ORN73DYoseph Barry L · Olympia, WAN73DCTwin Aviation LLC · Liberty Hill, TXN73DXAj Airlift LLC · Arlington, MAN73ECBronisevsky Robert · Old Bridge, NJN73ESWilmington Trust Co Trustee · Wilmington, DEN73FQAlaska Island Air Inc · Togiak, AKN73FRWayman Luy LLC · Weston, FLN73FTBerecz Kevin · Parrish, FL
Back to AD 81-18-04 R2