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.
N8948YKilpatrick Kerry · Somerset, NJN89492Pilot Farm LLC · Grant, NEN8949CMorgan Aviation LLC · Greensboro, NCN8949JSchmidt Roger L · Plattsmouth, NEN8949RMorten Jesse L · Larimore, NDN8949WSullivan Sean · Fort Worth, TXN8949ZBills Mark W · Willow, AKN894ACAri Ben Aviator Inc · Fort Pierce, FLN894ALLancaster Wesley A · Saint Augustine, FLN894CDSykes Richard D · Longmont, CON894CPCivil Air Patrol · Maxwell Afb, ALN894EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN894FSMiller Dietrick J · Monte Vista, CON894KCFlight Training Aircraft LLC · Wilmington, DEN894MAHot Wings Aviation LLC · Indianapolis, INN894MJWaite Richard H · Sun Valley, IDN894NDUnd Aerospace Foundation · Grand Forks, NDN894RVCox Aaron D · Kalama, WAN894YPodunk Planes LLC · Boulder, CON895Ghosh Abhimanyu · Mojave, CAN89503Menne Aviation LLC · Brooklyn Park, MNN8950FAloft · Haiku, HIN8950MPacific Flight Academy LLC · Honolulu, HIN8950UManley Steven T · Dallas, TXN8950WEthington Scott · Emmett, IDN8951DChadwick Stewart · Yuba City, CAN8951JMoehle Colleen M · Lincoln, ILN8951LWoolslayer John P · Tulsa, OKN8952CZell Zulu LLC · Greensboro, NCN8952WPollock William J · Agawam, MAN89531Glynco Manning Aviation Inc · Brunswick, GAN89533Ashby Shawn Alan · San Luis Obispo, CAN89539Jkg LLC · Murfreesboro, TNN8953DVassal Ministries · North Pole, AKN8953WKinser Aviation LLC · Guthrie, OKN89549Jodkin Jason J · Confluence, PAFirst renewal noticeN8955WSides Michael E · Bartley, NEN8955YCarter Howard A III · Stafford, VAN8956Martini Philip D · Bethel Park, PAN8956CCosper Rodney S · Killeen, TXN8956JBays Bob D · Jasper, MON8956WHalleck Brandon R · Terre Haute, INN8956YDark Side Aeronautical Inc · Wilmington, DEN8957CTracon Aviation LLC · Winter Springs, FLN8957JAirplane LLC · Farmington, UTN8957VN8957v LLC · Fort Lauderdale, FLN8958English John H · Pittsburg, TXN89585Vinland Flight School LLC · Topeka, KSN89588Jet & Rotor Aviation LLC · Sacramento, CAN8958CWinter John T · Tucson, AZ
Back to AD 81-18-04 R2