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.
N615SSSmith Stephen · Erwinna, PAN615TWClark Jim W · Claremore, OKN615VMBas Part Sales LLC · Greeley, CON615WTOwensby Paul T · Fayetteville, NCN61605Blake Ernest Ronald · San Jose, CAN61606Swafford Charles T · Humble, TXN61607Maier Dennis J · Morristown, SDN6160JKirby Alan F · Imperial, MON6160MHaverstock Richard T · Monterey, CAN6160PBbg Air Ventures LLC · Chandler, AZN6160WSteinsvik Magne · Seattle, WAN61610Sugarpine Skies LLC · San Jose, CAN61615High Flight Academy LLC · Allison Park, PAN6161LPlesetz Philip · Manitowoc, WIN6161STeklinski Andrew · Indian River, MIN6161VWorkman Lonnie H · Farmington, ARN6161WCarlson Darrin E · Clay Center, KSN61622Lexington Flying Club · Richmond, KYN61625Chapline Curtis · Cypress, TXN61628Nationwide Aviation LLC · Hudson Oaks, TXN6162PKiester Michael E · Duncan, OKN6162VAir Ventures Hawaii LLC · Lihue, HIN6162WEvans Stephen M · Vashon, WAN6162ZHolloman Afb Aero Club · Holloman Afb, NMN61630Jerome Pester Farms Inc · Hingham, MTN61631Jones Donald T Jr · Barrigada, GUN61633Rotor Spec Aviation LLC · Fort Lauderdale, FLN61635Meridian Aero Club Inc · Midland, MIN61637Amelia Reid Aviation LLC · San Jose, CAN6163DBistline John A · Cedar City, UTN6163FVagabond Flying Association · Winfield, ILN6163PCommache Avn Inc · Flint, MIN6163WLang Michael R · Cedar Key, FLN61640Cooper Michael A · Rohnert Park, CAN61641Handzo Anthony J · Roseville, ILN61642N61642 LLC · Lowell, MIN61643Spence Stephen E · Mancelona, MIN61645Lima-001 LLC · Muscatine, IAN6164DSeligson Andrew · Tuckahoe, NYN6164FBlue River Aviation LLC · Palmer, AKN6164JSchumar James F · Grand Rapids, MIN6164WSmith Steve W · Elizabethtown, KYN61651Clw Aviation LLC · Springville, ALN61655Air Planes LLC · Soddy Daisy, TNN61656Dismang Chad C · Boynton, OKN61657Bell Ornithopters Flying Club Inc · Eastlake, CON61658Nationwide Aviation LLC · Hudson Oaks, TXN61659Bowerman Richard E · Wetmore, MIN6165LGjorvad Steven A · Punta Gorda, FLN6165WSommers Wesley A · Kiana, AK
Back to AD 81-18-04 R2