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.
N8879NBesheer Susan Anita · Palm Springs, CAN8879YWelstad Blaine L · Newburg, NDN887BCAustin Aviation LLC · Boise, IDN887BHAir Ventures LLC · Sequim, WAN887CCMr Dent Inc · Manheim, PAN887CPCivil Air Patrol · Maxwell Afb, ALN887DMorrow David L · Waterloo, IAN887EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN887KJCf Aviation Trust LLC Trustee · Wilmington, DEN887PAReall George Dan · Castle Rock, CON887PMHarris William M · Radford, VAN887QRCornford Craig H · San Diego, CAN887WCGalindo Don R Jr · Walnut Grove, CAN8880LMellanby Nicholas S · Saint Louis, MON8880NAnderson Aviation LLC · Bulverde, TXN8880SJohnson Kenneth E · Mahtomedi, MNN8880YPlane Fun Inc Tr Trustee · Snellville, GAN8881CMcintosh Ronald J · Walker, WVN8881VLien Ronald N · Gilford, NHN8881WYellow Flyers Inc · Sioux Falls, SDN88828Yon Joseph W Jr · Pendeleton, SCN8882ERandall Christopher D · Northridge, CAN8882FCirrus Services Inc · Fargo, NDN8882JWisian Hans C · Boerne, TXN8882LRegistered aircraftN8882VTop Aircraft Leasing LLC · Wilmington, DEN8882WFleet James Reginald Jr · Jacksonville, FLN8883Harris James H · Gardner, KSN88838Flyers Park Farm LLC · Newark, OHN8883CBall Travis W · Aleknagik, AKN8883JRegistration Pending · Midlothian, TXRegistration pendingN8883NWarner Alexander Douglas · Grand Rapids, MIN8883YYank N Bank LLC · Greeley, CON8884CHartman Linda C · Malin, ORN8884DJ C Aero LLC · Yelm, WAN8884NDubois Jerry · Oklahoma City, OKN8884WFolse Eldred · North Las Vegas, NVN8884YFlight Logistics LLC · Westerville, OHN8885HHoughton Patrick K · Villa Rica, GAN8885JWeise David D · Marion, TXN8885WBarker Theo G T · Loveland, CON8885YWilson Cecil · Lithonia, GAN8886WTuggle Rodney J · Kansas City, MON8887CHorinek Troy C · Goodland, KSN8887FNiec Steven M · Clio, MIN8887JWeskap LLC · West Grove, PAN8888EFieseler Ronald G · Blanco, TXN8888JSnapp Steve J · Los Alamos, NMN8888LDorian Paul Joseph · Auburn, WAN8888NGibson Edward J · Marmora, NJ
Back to AD 81-18-04 R2