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.
N5982UCapital Aviation LLC · Fuquay Varina, NCN5982WHarris Chad A · Hamilton, ALN5983DGoodell Rebecca S · Sedro Woolley, WAN5983HMccormick Michael V · Waller, TXN5983LWatson Thomas M III · Lampasas, TXN5983MPhilipp Michael W · Thief River Falls, MNN5983USale Reported · Adelanto, CASale reportedN5983WAnderson Kerri · Frazier Park, CAN5984HJohnston Brian J · Ironwood, MIN5984QSlow Walkin Barnstormers LLC · Frostproof, FLN5984SBoswell Kurt R · Renton, WAN5984UDenton Richard A · Plant City, FLN5984WN4036r LLC · Quinton, ALN5985PDavis Marc E · Hillsboro, ORN5985QInderkummen Jean Pierre · Gulfport, MSFirst renewal noticeN5985WSterling West Corp · Camden, DENon-citizen corporation, flight hours not reportedN5985XWestern North Carolina Air Museum · Hendersonville, NCN5985ZHinds Clinton W · Kasilof, AKN5986LJilot Richard F · West Monroe, LAN5986QFord Christopher D · Brunswick, GAN5986UHolt Drew R · Lake Jackson, TXN5986VLampin Aviation LLC · Brielle, NJN5986WActon David D · Thousand Oaks, CAN5986XPanella Benjamin · Wampum, PAN5987HFarrell Tom · Sterling, AKN5987QHardesty William A · San Diego, CAN5987UBergquist Carol F · Saint Paul, MNN5987WWilson Brandon · Bozeman, MTN5988DNewburg Lyle X · Sparta, WIN5988QLynn Seth D · Killeen, TXN5988UPayan Oscar A · Teaneck, NJN5988WWest Central Aviation LLC · Prinsburg, MNN5988ZStevenson William E · Sutton, AKN5989DBoss Kevin J · Coventry, RIN5989WSmith Kevin L · Peachtree City, GAN598APiper Archer Three LLC · Wilmington, DEN598MCTeichroeb Peter · Seminole, TXN598MTMiddle Tennessee State University · Murfreesboro, TNN598NDBremfour Aviation Group Inc · Wilmington, DEN598SCSpartan Education LLC · Tulsa, OKN598SDMatlosz Daniel · Cranford, NJN598SPFb Aviation LLC · Minot, MEN5990EManeuvering Speed Inc · Wilmington, DEN5990QShowman Benjamin J · Danville, ALN5991HReynolds Eric F · Princeton, MNN5991LSlomer James A · Cheswick, PAN5991QBain Douglas D · Vega, TXN5991UDiggle Kenneth A · Coventry, RIN5991WChickasha Wings Inc · Chickasha, OKN5992QFriday Ryan M · Elizabeth, PA
Back to AD 81-18-04 R2