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.
N56324De Melo Marcelo Ramos · Vinton, VAN56325Glaser John · Merritt Island, FLN56326Abernathy Spraying Service Inc · Tipton, OKN56328Registration Pending · Camarillo, CARegistration pendingN5632AHerrin David R · Patterson, GAN5632LLas Vegas Aerial Services LLC · Las Vegas, NVN5632RInternational Air Services Inc Trustee · Carson City, NVN5632USale Reported · Montgomery, ALSale reportedN5632ZEakin Andrew C · Franklin, PAN56332Smith Paul G · Wasilla, AKN56335Maule Air Inc · Moultrie, GAN56339N56339 LLC · Lebanon, OHN5633BGood Airplanes LLC · Oshkosh, WIN5633HDunne Terence J · Wasilla, AKN5633LCavenagh Thomas D · Lawton, OKN5633PPride Lawrence E · Poway, CAN5633QKeene John D · Spotsylvania, VAN5633UStaples Clint B · Glen Rose, TXN5633WWenzel Mark B · Algona, IAN5633ZMulder Gene D · North Sioux City, SDN56343R&T Wings LLC · Lewes, DEN56344Rogers Steve M · Brenham, TXN56347Smith Dale · Windsor, CAN5634LOlson Mitch A · Silver Springs, NVN5634PWaters George A · Oklahoma City, OKN5634SSmb Air Inc · Crescent Springs, KYN5634WEagle Vision LLC · Hamer, IDN5634YPottenger Charles R · Lewiston, IDN56350Aerospace Technology Group Inc · Temecula, CAN56353Groux Zachary Brian · Spring, TXN56355Vectair USA LLC · Olive Branch, MSN5635DZuber Gary D · Culver, ORN5635ECircle W Flying Club Inc · Creighton, PAN5635LCentury Air Inc · Fairfield, NJN5635MGlenn Brian J · Boise, IDN5635NMann David · Glenn, CAN56363Romzick Peter G · Oxford, MIN56367N56367 LLC · Manassas, VAN56368Performance Aircraft Sales Inc · Lincoln, NEN5636DSorensen R L · Soda Springs, IDN5636HRobertson James S · Welsh, LAN5636LCrosby Thomas G · Saint Charles, MON5636MThorpe Caleb D · Las Vegas, NVN5636NSummit Aviation Holdings Of Nwa Inc · Rogers, ARN5636PBarley Austin D · Red Lion, PAN5636QKelly Thomas J · Henderson, TXN5636UMontie Michael · Fairview Park, OHN5636WWatkins Micah · Queen Creek, AZN5636ZYoung Harold E · Jamestown, NYN56370Grosgebauer Bryan R · Ogden, UT
Back to AD 81-18-04 R2