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.
N860TWSun City Air Charter LLC · Davie, FLN860UBoard Of Regents Of The University Of Oklahoma · Norman, OKN8610CRuss Robert P · Van, TXN8610NSkipper Donald J · Huntersville, NCN8610RTener Dean R · Lisbon, OHN8611VAlbright Harold R · Dubois, WYN8611WSheppard Travis · Terrebonne, ORN8611YCragg Gordon E · Georgetown, TXN8612DPerry Leonard M · Soldotna, AKN8613DPerry Kenneth V · Katy, TXN8613VBoley Trevor T · Palmer, AKN8614CErdmann Adam C · Raseau, MNN8614PLee Patrick J Jr · Lindstrom, MNN8614WRegistration Pending · Grand Junction, CORegistration pendingN8614YD&D Maintenance LLC · Etna Green, INN8615VCitabria N8615v LLC · Westminster, CON8615WJefferson Community & Technical College Foundation · Louisville, KYN8615YUniversity Of Alaska Anchorage · Anchorage, AKN8616DFrancis Harvey B · Key West, FLN8616VPittman Michael · Goodridge, MNN8616WKlopsch Steven J · Colbert, WAN8617DGrisham Michael H · Paulden, AZN8617HToutant Roland J · Woodstock, CTN8617PFrisbie Kevin R · Fairfield, IAN8617WHacker George A · Renton, WAN8617YBurton David A · Pepperell, MAN86181Neel Bradley H · Lakeland, FLN86183J L Air LLC · Wilmington, DEN8618LLatimer Lawrence A · Vernon, TXN8618YGroup Aire II · Manitowoc, WIN86198Styer David B · Pendleton, ORN8619ACowboy Up Aviation LLC · Frenchglen, ORN8619DBenton Mark H · Sussex, WIN8619EHogan Daniel L · Chapel Hill, NCN8619LAerial Banners Inc · Pembroke Pines, FLN8619PStewart Mark A · Mccall, IDN8619VPlane Folks LLC · Tucson, AZN8619YNuse Aviation LLC · Hollidaysburg, PAN861ACGuglietta Glenn W · Payson, AZN861APKlein Edwin Andrew Bell · Grass Valley, CAN861ATChristiansen Aviation LLC · Wilmington, DEN861AUAuburn University · Auburn University, ALN861BABarr Air Patrol LLC · Mesquite, TXN861CDHansell David A · Windsor, CON861CHPope James D · Lewiston, IDN861CPCivil Air Patrol · Maxwell Afb, ALN861EREmbry-Riddle Aeronautical Univserity Inc · Daytona Beach, FLN861GCDutton Aviation LLC · Fayetteville, GAN861KSKansas State University · Salina, KSN861MMGiordano Matthew J Jr · Wilmington, DE
Back to AD 81-18-04 R2