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.
N89681Wings Over Texas Holdings LLC · Denton, TXN8968CDowd John J Jr · Syracuse, KSN8968DCleary Katherine E · Mulberry, FLN8968JStevens Raymond W · Norfolk, VAN8968LAg Aircraft Holdings LLC · Port Saint Lucie, FLN8968QSonnichsen Landen D · Delta Junction, AKN8968VLittle Gordon D · Watertown, SDN8968WRc Skywagon LLC · Miami, FLN89693Rjw Aviation LLC · Tampa, FLN8969CStrahl Guenter H · Jackson, NJN8969VCrowley Brett A · Wasilla, AKN8969WPostage Robert · Chapel Hill, NCN8969YTrident Aero Services LLC · Park City, UTN896ACAri Ben Aviator Inc · Fort Pierce, FLN896AFAmeriflyers Of Texas Inc · Addison, TXN896AKQuadcub Utah LLC · Salt Lake City, UTN896ASSilverstein Adam R · Pittstown, NJN896B49 Holdings LLC · Cheyenne, WYN896BCClute William A · Simpsonville, SCN896CFMiles Air Leasing LLC · Canonsburg, PAN896CPCivil Air Patrol · Maxwell Afb, ALN896DFVenture North Aviation LLC · Cloquet, MNN896DLLane David A · Yuba City, CAN896JUniversity Of North Dakota · Grand Forks, NDN896NDUnd Aerospace Foundation · Grand Forks, NDN896SCHansen Ernest F · Sequim, WAN89702Carter Flygare Inc · Sacramento, CAN8970CMcdonald Todd P · Fairbanks, AKN8970JAll Tech Machine & Tool Inc · Greenwood, ARN8970VWinding Creek Aviation LLC · Snellville, GAN8970WYoungblood Wade · Corsicana, TXN89718Schad Paul E · Gainesville, TXN8971DThomas James W · Jay, FLN8971JSwearingen Louis S · Summerfield, FLN8971MDixon Gary Lynn II · Ooltewah, TNN8971PDerrel Luce Pc · Waco, TXN8971VGibson Aviation Services LLC · Hudson, WIN8971YLaubscher John E · Cazenovia, NYN89721Propability One LLC · Daytona Beach, FLN8972CBosn Richard O · Scottsbluff, NEN8972DClarke Timothy B · Howard, SDN8972JPascua Jonathan J · Coventry, RIN8972VPearce Michael J · Phoenix, AZN8972WIma Pilot LLC · Sauk Rapids, MNN89735N89735 LLC · Stuart, FLN8973CUrbach Jourdan B · Sherman Oaks, CAN8973DSnider Scott E DBA · Turner, MTN8973FAvelan Enterprises Inc · Elm Grove, LAN8973JMuleshoe Flight Club LLC · Muleshoe, TXN8973VOcean Flyers LLC · Chatham, NJ
Back to AD 81-18-04 R2