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.
N83PHValiair Limited Co Trustee · Casper, WYN83PJSupan David M · Elk Grove, CAN83PSBurt Donald H · Mason, MIN83PYDecino Robert D · Fritz Creek, AKN83RAardema Robert J · Kalamazoo, MIN83RLPowers Jerry · Moriarty, NMN83RQBlais Michel · Jackson, TNN83RTWilliamson Tracy C · Texarkana, TXFirst renewal noticeN83SFChristiansen Aviation LLC · Wilmington, DEN83SLRegistration Pending · Houston, TXRegistration pendingN83SMMain Aviation LLC · Naches, WAN83TMCimino Joseph Michael · Decatur, ALN83TTL1 Air LLC · Wilmington, DEN83TXPike Alan D · South Portland, MEN83VSherrer Eric W · Santa Paula, CAN83VCDoke Ken L · Winton, CAN83VVMccaul Benjamin · San Luis Obispo, CAN83WJSikes Randell D · Dandridge, TNN83WYN265bn LLC · Waterloo, NEN83ZCrittenden William F · Spokane Valley, WAN84001Darcy Aviation LLC · Danbury, CTN84007Smith Michael W · Sharon, CTN84009Swenson Catherine A Trustee · Meadow Vista, CAN8400F337 Skymaster Inc · Miami, FLN8400LInstant Print Signs & Designs LLC · Kalispell, MTN8400SParks Perry A · Goodell, IAN84014C-140 Company LLC · Milton, FLN84015Tarakji Mohamad Hani A · Van Nuys, CAN84019Snodgrass William D · Moberly, MOFirst renewal noticeN8401BSale Reported · Crofton, KYSale reportedN8401FSchriner Keith D · Lanark, ILN8401LBlack Baron Air LLC · Kalispell, MTN8401RLaplante David W · New Baltimore, MIN8401SRg Aviation LLC · Fulton, MSN8401TWingsleasing LLC · Wichita, KSN8401VGlenn Larry W · Bunn, NCN84023Sidoti Charles A · Boston, MAN84024Maurano Michael R · Long Island, VAN84026Smith William A Jr · Tulsa, OKN8402BMays Richard N · Lakeway, TXN8402CConner W Larry · Los Lunas, NMN8402LVan Bortel Inc · Victor, NYN8402RLivengood Leasing Co LLC · Mesa, AZN8402SHigh Noon Leasing LLC · Anchorage, AKN8402WAnderson Thomas · La Quinta, CAN84032Eide Donald B Trustee · Webster, MNN84036Wings Over Texas Holdings LLC · Denton, TXN8403BVolare Via LLC · Piqua, OHN8403LAarow Aircraft Leasing LLC · Mcminnville, ORN8403RSenmounnarath Sam · Murfreesboro, TN
Back to AD 81-18-04 R2