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.
N9757JCarbiener Diane M · Kewanee, ILN9757LGasper Joseph · New Port Richey, FLN9757TDevevo Warren C Sr · Sylvania, GAN9757UFairchild James C · Pinson, TNN9757WTld And Company LLC · Trenton, FLN9758BSherwood Aviation LLC · Lewes, DEN9758DEvans Michael K · Nome, AKN9758JKiarsis Stephen G · West Wareham, MAN9759HHavelka Glen C · Boerne, TXN9759JLazy H LLC · Carleton, NEN975AAEmez Holdings LLC · Boca Raton, FLN975ACNaples Air Center Inc · Naples, FLN975BESaucerman & Company LLC · Hampstead, NCN975BMMeier Frank I Jr · Twin Lakes, WIN975BSSaurdiff Benjerman D · Two Rivers, AKN975BWWeidendorf Investments LLC · Hinckley, MNN975CPCivil Air Patrol · Maxwell Afb, ALN975DGPhillips Duke · Hyattville, WYN975DSJpm Aviation LLC · Irvine, CAN975GPSalah Danny · Moraga, CAN975LEBlue Borracho LLC · Manitou Springs, CON975LLWoodhouse William H · Power, MTN975PKMaisel Chad · Plano, TXN975RVArvai Joseph · Elkridge, MDN975SGage Christopher R · Truckee, CAN975TAMitchell David G · Cadiz, OHN975THAnson Air LLC · Sugar Land, TXN975VTDodd Park A · Richmond, VAN976Green Alexander · Germantown, TNN9760CStreet Steven J · Rochester, MIN9760DDavis Michael P · Midway, UTN9760JHanks Cathy J · Danville, KYN9760MNeal Alan B · Cherry Valley, CAN9760UFitzgerald John P · Pittsburgh, PAN9760WRegistered aircraftN9761PBig Q Aviation Corporation · Helena, MTN9761WRivera-Osorio Karolina · Monroe, NYN9762DMarshall Marcus D · Georgetown, TXN9762PKnutson Wayne R · Thompson, NDFirst renewal noticeN97632Henderson James L · Jackson, MSN9763HReed Grain & Bean Inc · Buhl, IDN9763JShaffer Timothy R · Marion, IAN9763MWaldren Paden · Garden Valley, CAN9763TBiotech Vending LLC · Escondido, CAN9764FFixed Wing Holding Co Inc · Pembroke Pines, FLN9764KSchoff Wardell R · Hamilton, MON9764MSilcott Robert W III · Fairview, OKN9764WMich John D · Fort Morgan, CON97650Updraft LLC · Kissimmee, FLN9765DPatey Daniel J · Lakewood, CA
Back to AD 81-18-04 R2