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.
N9957QHarmon Michael D · Mansfield, SDN9957UTurner Steven R · Westfield, INN99583Motz Gary A · Bemidji, MNN99589Kingsky Flight Academy LLC · Lakeland, FLN9958DMoore William H · Johnstown, CON9958LGilbert Michael D · Grants Pass, ORN9958YZimmerman Tom V Jr · Fairbanks, AKFirst renewal noticeN99598Registration Pending · Argyle, TXRegistration pendingN9959DJohnson Steven Donald · Pardeeville, WIN9959LIkaros Aviation Group Inc · Naperville, ILN9959UGunji Harold H · Lawrenceville, GAN995CCN995cc LLC · Fredericksburg, TXN995FGFlightgest Academy LLC · Morrisville, NCN995JAN995ja LLC · Ft Lauderdale, FLN995JMMaurer Manfred F · Maineville, OHN995NRAnthelion Helicopters · Long Beach, CAN995RVRhoden Richard C · Friendswood, TXN995THVold Jon K · Hallock, MNN995VZMeyerowitz Noah A · Great Barrington, MAN995WN995w LLC · Salem, ORN995WMHangar 7 Aviation LLC · N Redngtn Bch, FLN995WWMoore Aviation Inc · Beaver Falls, PAN99606Civil Air Patrol Inc · Maxwell Afb, ALN9960LRegistered aircraftN9960UFletchair Inc · Comfort, TXN9961ERuryk Jonathan D · Pineville, LAN9961UAam Leasing LLC · Zeeland, MIN9961VCk Leasing Services LLC · Wilmington, DEN9961WViper Enterprises LLC · Rolla, MON9962LHjermstad Scott J · Louisville, NEN9962QErvin Scott A · Tumwater, WAN9962UJones Randall Bryan · Palm City, FLN9962WSuggs Kaycen M · Grifton, NCN9963DBurlak David M · Waverly, VAN9963EDenski David T · Plymouth, MIN9963LQuadrex Associates Inc · Indialantic, FLN9963QAnderson Darrin J · Palmer, AKN9963URansom James R · Modesto, CAN9964KState Of Wisconsin Department Of Administration · Madison, WIN9964LHess Garrett J · Fullerton, CAN9964QVer Schneider Nicholas R · Forestport, NYN9964WRawlins James III · Saint Charles, MON9965PAmeriflyers Of Texas Inc · Addison, TXN9965QDms Leasing Co LLC · Las Vegas, NVN9965UEdward Brent M · Meridian, IDN9966DZiemann Shaun · Jasper, INN9966QParker Christopher W · Penngrove, CAN9966VLeisner David L · Palmer, AKN9967CJoemac Business Services LLC · Casper, WYN9967QTaildragon LLC · Boise, ID
Back to AD 81-18-04 R2