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.
N945TELebanon Flying Club Inc · Lebanon, TNN945TLShirley Mae LLC · Franklin, MIN945UMd Ag Services LLC · Sterling City, TXN945VKTiedemann Daniel W · Carmel, INN945XPeraton Services LLC · Bozeman, MTN94609Heavy Metal Air LLC · Farmingdale, NYN9460BEdwards Ag Service · Primghar, IAN9460DOlsen Marr B · Kelseyville, CAN9460JDerosa Michael D · Hewitt, TXN9460VDodie Aviation LLC · Sheridan, WYN94618Flight Trainer LLC · Wilmington, DEN9461CClub Cherokee Inc · Crystal, MNN9461DDurghinescu Cris Nicolae · Rancho Mirage, CAN9461JKobbeman Joseph B · Louisville, KYN9461LAnthonson Ronald G · Cortland, NYN9461NJames Neville & Company Inc · Ocala, FLN9461PErickson Jess L · Saco, MTN9461VZembraski Jeffrey · Nocona, TXN94626New Horizons Aviation Inc · Goshen, INN9462DEvans Randall Btrustee · Fallon, NVN9462LBrake Kevin · Mars, PAN9462NLombardo Gene S · New Bern, NCN94631Flight Trainer LLC · Wilmington, DEN9463DHarris Aircraft Leasing Co · Oklahoma City, OKN9463KRegistered aircraftN9463LFlight Trainer LLC · Wilmington, DEN9463VHatcher Mark F · Aloha, ORN9463WHassebroek Leroy A · Little Rock, IAN9464D907 Aviators LLC · Eagle River, AKN9464JReinert Roger J · Duluth, MNN9464LLehman Logan R · Front Royal, VAN9464NTempleton Katherine M · Madison, WIN9464WHollingsworth Ronald W · Shawnee, KSN94652Maryak Hans F · Somersworth, NHN94655Iowa Great Lakes Flyers Inc · Cheyenne, WYN94659Pavco Inc · Gig Harbor, WAN9465DMehrer Fritz J · Oceanside, CAN9465JTaylor Robert J · Woodbridge, VAN9465NStenhouse Place I LLC · Fountain Inn, SCN94661Fjiro Aviation N94661 LLC · Vancouver, WAFirst renewal noticeN9466DGerrard Michael K · Kaysville, UTN9466EGood Flight Aviation LLC · Stockton, CAN9466JHawk Aviation Academy LLC · Saint Petersburg, FLN9466KSpanaflight LLC · Puyallup, WAN9466LEastern Slope Aviation Academy · North Conway, NHN9466NWingert Douglas L · Smithfield, KYN9466PNewton Bros · Stratford, CAN9466WDisorbo Stephen S · New Milford, CTN9466XFlight Trainer LLC · Wilmington, DEN9467Allen Lanny Dean · Indianapolis, IN
Back to AD 81-18-04 R2