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.
N8414LMorris Christopher J · Manor, TXN8414M8414m LLC · Nunica, MIN8414NAirlake Aero Inc · Lakeville, MNN8414RVick Justin M · Morton Grove, ILN8414VWeller Steven C · Hummelstown, PAN8414WOhmacht Carlton J · Glenwood, MNN8414YLone Oak Aviation LLC · Greenville, NCN8414ZCunningham Stanley A · New Braunfels, TXN84151Sanders George W · Cloverdale, INN84153Spirit Air Inc · Salmon, IDN8415FGrediagin Wayne · Anchorage, AKN8415HAeronautica Aviation Inc · Port Orange, FLN8415PFathoms LLC · Leland, MIN8415RMahanna John A · Radcliff, KYN8415YSchwend Brian · Forsyth, MTN84162Crosswind Aviation Of Oklahoma LLC · Stillwater, OKN84169Roach Gene T · Frankfort, KYN8416JEmerald City Aircraft Leasing Inc · Port Orchard, WAN8416K8090 Alpha LLC · Grayslake, ILN8416RExpert Staffing West Inc · Ramona, CAN8416WCass Aviation LLC · North Las Vegas, NVN8416YHenze Charles R · Waukee, IAN84170Follmer Todd F · Dunwoody, GAN84176Brandywine Flight School · West Chester, PAN8417CDolan Joseph B · Baltimore, MDN8417JAtkinson Joseph M · Phoenix, AZN8417YHighhouse Alan J · Honesdale, PAN84183Chickadee Aviation LLC · Burr Ridge, ILN84185Harrison Gene R · Pendleton, ORN84186Gould George Jr · Bryantville, MAN8418CWingman Aircraft Repair Inc · Lawrenceville, GAN8418ETri-State Waterstoppers LLC · Ruffs Dale, PAN8418JBrown Jerry D · Rio Rancho, NMN8418RCarlsson Carl J · Mason City, IAN8418WMadison Mike · Pittsburg, TXN8418YHefner Joseph C · Mount Pleasant, TXN84190Frs & Craig Llp · Byron, GAN84193Smirnov Alexei · Fair Lawn, NJN84194Ultra Aviation LLC · Cedar Bluff, VAN84195Norcal Flight Center LLC · Lincoln, CAN8419CMarsh Geoffrey E · Old Lyme, CTN8419HHoke William Jr · Charlestown, INN8419JHammonds Hangars Inc · Wilmington, DEN8419RLytle Cole · North Palm Beach, FLN8419YMorrone Richard W · Westerly, RIN841ACooper Jerry A · Kennewick, WAN841AKOld City Helicopter Sales LLC · Saint Augustine, FLN841BKKilpatrick Joseph C · Atlanta, GAN841CMTalley-Sickles Jacqueline M · Oxnard, CAFirst renewal noticeN841EDR&D Aviation LLC · Fayetteville, GA
Back to AD 81-18-04 R2