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.
N80KMMcphillips Flying Service Inc DBA · Beaver Island, MIN80LCHubbert Stephen A · Newcastle, OKN80LSClow Streeter M · Mansfield, OHN80LTEastern Stearman Inc Trustee · Leesburg, VAN80LULetourneau University · Longview, TXN80MLBishop Jack · Sabina, OHN80MMTodd Patrick A · Lockeford, CAN80PBMulrooney William G · Mooresville, NCN80PDGatpandan Grace Michele V · Martinez, CAN80PELakepoint Aviation LLC · Augusta, KSN80PLLeckman Paul · Bothell, WAN80RVAllen James R · Olympia, WAN80SBBrewer Renner L Jr · Sonora, CAN80SCRichards Brian · Aledo, TXN80SDLake Area Technical College · Watertown, SDN80TRRender Thomas R · Eden Prairie, MNFirst renewal noticeN80UFWerner William S · Melbourne, FLN80UMGoodman Christopher W · Hammond, LAN80WDParakka Anthony P · Rockford, ILN80XLWolf Lawrence A · Wyoming, OHN80YRInternational Engineering & Sourcing · Oklahoma City, OKN81006Wicked Wings LLC · Norwood, NCN8100NSpeicher Peter · Grand Forks, NDN8100PBaluch Adam · Medina, OHN8100THwang Glenn · Glen Carbon, ILN8100WWaggoner Alan L · Blanchard, OKN8100YHagaman Boynton C · Berryville, VAN81013Saratoga N81013 LLC · Santa Rosa Beach, FLN81014Beccario Joseph P · Sault Sainte Marie, MIN81016Lane Community College · Eugene, ORN81018Robinson David · Camas, WAN81019Bishop Luke · Fort Worth, TXN8101AGryczemski John Z · Olive Branch, MSN8101DZambrano Holdings LLC · Port Orange, FLN8101PFosters Aviation · Idaho Falls, IDN8101SAirborne Ministries · Littlefork, MNN8101TWimberly Fred N · Callao, VAN8101WMccooknet Inc · Mccook, NEN81021Paris Air Inc · Vero Beach, FLN81023Boettinger John G · Oak Lawn, ILN81024Jonsson Erik · Twin Falls, IDN8102BDayton Stephen · Littleton, NHN8102CFortenbarry David O · Anderson, SCN8102HEklof Gary L · Wayzata, MNN8102PWilliams William G · Lowell, VTN8102SJl Holdings Ntx LLC · Flower Mound, TXN8102WGutierrez Juan · Sarasota, FLN8102YAlexander Wesley L · Nenana, AKN81034Registered aircraftN81035Martin William F · San Antonio, TX
Back to AD 81-18-04 R2