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.
N614EREmbry-Riddle Aeronautical University Inc · Prescott, AZN614FAHillsboro Aero Academy LLC · Hillsboro, ORN614FLEagle Sky Patrol Inc · Deadwood, SDN614GVVouga Greg M · Fuquay Varina, NCN614JDCc Aviation Inc · Tracy, CAN614JMLynch Bradley J · Fenton, MON614JTPorter Scott · Aguila, AZN614KDDixon Kenneth P · Arvada, CON614LFLunken Flight Training Center LLC · Cincinnati, OHN614MMoonbeam Management LLC · Longwood, FLN614MATwinair LLC · Junction City, WIN614MBStarlight Express LLC · Bellevue, WAN614MTTrivundza Marko R · Saint Louis, MON614PSAeronaut Technolgy LLC · Jacksonville, FLN614PWAlpha Victor 8 LLC · Broken Arrow, OKN614RSecker David · San Jose, CAFirst renewal noticeN614RFBerry Charles P · Monroe, NCN614RGLittle Shiz Llcr LLC · Kalispell, MTN614SCRunamuck LLC · New Orleans, LAN614TVDurmisevich Dean J · Carnation, WAN614VZVision Aircraft LLC · Scottsdale, AZN614WMCarbonell Terry L · Alva, FLN614WTJamestown Jet Center Inc · Jamestown, NDN6150DPayne David J · Eagle River, AKN6150FFranklin Aviation LLC · Paradise, CAN6150JCypress Aviation LLC · Malvern, PAN6150LRucks Chad W · Okeechobee, FLN6150MJprg Aviation Inc DBA · Orlando, FLN6150PCobb Berrien · Smyrna, GAN6150RChristy David L DBA · Meriden, KSN6151HFly Aviation Corp · Wilmington, DEN6151PRoberson Michael B · Winterville, NCN6151ZRotor And Wing LLC · Tioga, NDN61526Mata Joseph F · E Setauket, NYN6152DFort Wolters Helicopter Inc · Mineral Wells, TXN6152HMarcair Inc · Fort Worth, TXN6152SN6152s LLC · Sheldon, NDN6152VClayton Stephen C · Conyers, GAN6152WRogers Samuel I · Leroy, KSN61531Aero Maintenance Inc · Vancouver, WAN61534Registration Pending · Cheney, KSRegistration pendingN61536Aerolanding LLC · Enterprise, ALN61539N61539 LLC · Arvada, CON6153JLange Scott A · Rapid City, SDN6153LMastrangelo John A · Phoenix, AZN6153SDanicic Sinisa · Jacksonville, FLN61544Knudsen Russell G · East Troy, WIN61547Frontline World Missions Inc · Jacksonville, TXN61548Adamson Daniel A · Moscow, OHN6154DRoss Winn J III · Rochester, IL
Back to AD 81-18-04 R2