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.
N812MAGould Emil Bradley · Chappaqua, NYN812MCFly Bye Air LLC · Southport, NCN812MNCarlisle Max · Fairview, OKN812NDUniversity Of North Dakota · Grand Forks, NDN812RRAstraeus LLC · Greenport, NYN812RSSears Richard A · Stevensville, MDN812SMSutton Aircraft Salvage LLC · Palmer, AKFirst renewal noticeN812SPHayes Edward B · Cedar Rapids, IAN812STAk8 Assets LLC · Talkeetna, AKN812THSuss Charles H · Woodford, VTN812TMJoslyn Robert A · Bristol, CTN81305Wadsworth Robert M · Wellesley, MAN8130DEmbree Walter G · Harrisonburg, VAN8130PBenedict Morris D · Kenly, NCN8130WAerospace Trust Management LLC Trustee · Wilmington, DEN8130XBuck Company LLC · Saint Louis, MON8130YDrummond James D · Oshkosh, WIN8131DThompson Arthur W · Paris, TXN8131PCheak Alan S · Peachtree City, GAN8131RPaphos Airways LLC · Farmingdale, NYN8131WGaudette Philip C · Woodstock, CTN8131XC&W Leasing · Cedar Rapids, IAN81321Treacy Richard K · North Massapequa, NYN81327Roman Maritza Torres · Toa Alta, PRN81328Morrical Dean R · Henderson, NVN8132BOptisure Risk Partners LLC · Manchester, NHN8132CRitel Copter Service Inc · Hudson, IAN8132PMiller Lawrence A · Winthrop Harbor, ILN8132WGore Robert E Jr · Aiken, SCN8132YJessen Eric Carl · La Luz, NMN81337Bandito Aviation LLC · Naples, FLN8133CCarter Marl · Coburg, ORN8133ELane Community College · Eugene, ORN8133JWarrior Aviation LLC · Stanford, KYN8133PChristy H Spencer · Wetumpka, ALN8133SWoodard David · San Diego, CAN8133YLeaders Bob O · Clear Lake, MNN81344November 46a Leasing Inc · St Augustine, FLN81345Bailey Roger I · Silverdale, WAN81347Tusha Kenneth R · Yankton, SDN8134CCentral Virginia Aviation Inc · North Dinwiddie, VAN8134DDewolf Logan J · Eagle River, AKN8134WBrilliant Holdings LLC · Winfield, MON81354Figueroa Lionel · Sacramento, CAFirst renewal noticeN81357Cascade Aircraft LLC · Eugene, ORN81359Tuckahoe Aviation LLC · Tequesta, FLN8135CCoverdale Aviation LLC · Ellendale, DEN8135DDickerson Joseph Ra · Anchorage, AKN8135GMiloud Chadd K · Fort Worth, TXN8135LTri County Rentals And Sales Inc · Bell, FL
Back to AD 81-18-04 R2