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.
N559DDRobinson Helicopter Co Inc · Torrance, CAN559ESeitan Eduard · Chicago, ILN559FLSandlak David J · Zephyrhills, FLN559JPNelson Scott E · Whispering Pines, NCN559JTOrian Dillon R · Malibu, CAN559MANorwood Kenneth Trustee · Rogers, ARN559MKBadawi Aviation LLC · Orlando, FLN559PTracy Theodore W · West Chester, OHN559PDCrocker Donald E · Eagle, IDN559PUSkyborne Airline Academy Inc · Vero Beach, FLN559RKRegistration Pending · Sheridan, WYRegistration pendingN559RVBrady Norman M · Port Orange, FLN559SGQualitair LLC Trustee · MichelstadtN559SP1.2 Gpa LLC · Rapid City, SDN559TJHangar 22 LLC · Watkinsville, GAN559WKleiss Norman J · Cloverdale, INN55ADSchrage Rodney L · Steamboat Springs, CON55AFRegistration Pending · Terre Haute, INRegistration pendingN55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKN55AHHancock James T · South Saint Paul, MNN55AJJudge Andrew L · Pinecrest, FLN55AMAdams Floyd R · Sebring, FLN55ATAugust Aero LLC · Kalispell, MTN55AUWallner Chris R · Petaluma, CAN55AVFood Service Installations Inc · Vancouver, WAN55BCMcconnell Bert J · Hudson, OHN55CRUltrapure Air LLC · Setauket, NYN55CYBonneville Aero Works LLC · Greenville, SCN55DACircle L J Aviation Inc · Plant City, FLN55DHAcmed Consulting LLC · Bradford, RIN55DPMagaw David N · Sacramento, CAN55DVDevine William L Jr · Maple Falls, WAN55DYBrown Carl A · Las Cruces, NMN55DZHuey Christopher D · Mesa, AZN55EDonnelly Mitch L · Mcloud, OKN55EKMengel David M · Monticello, INN55ELLynn Edward Wayne · Vancouver, WAN55EMIxi LLC · West Bloomfield, MIN55EWHanratty Brian James · Pismo Beach, CAN55FFSiedschlag Paul C · Granbury, TXN55GASaathoff Michael A · Stockton, MON55GBRivers Paul E · Shannon, ILN55GGAll Attitude Aviation Inc · Edgewater, FLN55GLBates John W · Westerly, RIN55GR55 Golf Romeo LLC · North Myrtle Beach, SCN55GTTurner William Hugh Vi · Belmont, CAN55HAHonaker Group LLC · Sellersburg, INN55HBStefanick Richard L · Morgantown, WVN55HNNaylor John H · Conway, ARN55HQHerndon Colton R · Smithville, MO
Back to AD 81-18-04 R2