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.
N569FLN7396w LLC · Coeymans Hollow, NYN569MKindred Daniel P · Jacksonville, ILFirst renewal noticeN569MTMiddle Tennessee State University · Murfreesboro, TNN569NDVertol Systems Co Inc · Destin, FLN569NEMcclung Aerial Spraying Inc · Big Springs, NEN569RVRicketts Michael D · Weirsdale, FLN569SPGlobal Flight Training Solutions Inc · Immokalee, FLN569TJAnderson Thomas C · Poplar Grove, ILN569TSBig South Fork Aero Inc · Huntsville, TNN569WHGp Cub Air LLC · Sioux Rapids, IAN56ABBezanson Adam M · Fremont, NHN56AMPeavy Michael J · Chico, CAN56BEBirds Eye View Inc · Middletown, RIN56BGGuernsey Gibson R · Belen, NMN56BSHansen Nick K · Litchfield Park, AZN56BVEuroaviation Inc Trustee · KematenN56CCMichel David L · Pickens, SCN56CEWave Shack Acquisitions LLC · Lewes, DEN56CPBulldog Aviation LLC · Goodyear, AZN56CVVaughn Geoffrey · Brunswick, GAN56CWLaurel Aviation Inc · Decatur, ILN56DBBerger Dale · Bay Village, OHN56DDMeier Perry S · Conroe, TXN56DFThorpe Arthur N Jr · Salisbury, MDN56DGEagle East Aviation Inc · North Andover, MAN56DWReed John S · Wasilla, AKN56EB56 Eb Inc · Jacksonville, FLN56ECBpc Aviation LLC · Rosamond, CAN56EKQuailair LLC Trustee · MichelstadtN56EPSanders Flight Training Center Inc · Jasper, ALN56ERGsell Bruce Ward · Southampton, NJN56FAir Kings LLC · West Chester, PAN56FDDefibaugh Fred M · Chino Alley, AZN56FJRocky Mountain Construction LLC · Klamath Falls, ORN56GBCalhoun Keith A · Springville, TNN56GH45g Aviation Services LLC · Fenton, MIN56GTDonaldson Timothy A · Oklahoma City, OKN56GUIdagus N56gu LLC · Miami, FLN56HCFaire Ken · Mojave Valley, AZN56HJRobinson Douglas J · Dayton, NVN56HRStrachan Annmarie C · Overgaard, AZN56HYCipolli Robert J · Montgomery, MAN56JDDignan Charles N · Telluride, CON56JFWadsworth Chad · Lake Havasu City, AZN56JSPoppy Wayne J · New London, WIFirst renewal noticeN56JUSurfield Ronald W · Leonardtown, MDN56KCCrawford William K · Ovilla, TXN56LAGroat Stanley G · Austin, ARN56LBArlington Flight Services Inc · Arlington, WAN56LGLake Skippers LLC · Park Rapids, MN
Back to AD 81-18-04 R2