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.
N592NDUnd Aerospace Foundation · Grand Forks, NDN592RJWood Roger E · Waxhaw, NCN592RSProbst Danny R · Nokomis, ILN592SExperimental Aircraft Assoc Portland Chap 105 · Canby, ORN592SCN592sc LLC · Inola, OKN592ZHorton Michael D · Vernal, UTN5930USplendid Air Leasing LLC · Dover, DEN5930WGraham James C Co-Trustee · Bellville, OHN5930ZBrue Peter Gary · Cedar Rapids, IAN5931DStone Robert K · Piney Flats, TNN5931LLuft Aviation Inc · Wilmington, DEN5931UJ And H Aircraft Leasing Inc · Palmyra, PAN5932Autry Marbella A · Montrose, CON5932FWingin' It Aviation LLC · Glendale, CAN5932URegistration Pending · Bulverde, TXRegistration pendingN5932WSchaaf Rodney B · Bowman, NDN5933DHoward Trent R · Mandan, NDN5933QDonaldson Lucas P · Owyhee, NVN5934DBalsley Matthew G · Rowlett, TXN5934HAlden Aviation Management LLC · New Smyrna Beach, FLN5934VLuvsflying Flight Training LLC · Staten Island, NYN5934WDear Stephen R · Pioneer, CAN5934ZNew Daniel A · Deming, WAN5935PDaniel Hardy L Jr · Derby, KSN59369Stewart Michael W · Snellville, GAN5936DSchreiber Faith E · Valparaiso, INN5936QEllis Robert L · Columbus, OHN5936ZMeulenberg Jacobus M J · Schenevus, NYN5937GD'Arge Ranyon Wc · Wilson, WYN5937HFrasier Samuel R · Archer, FLN5937PTindall Michael C · Granite City, ILN5937QPospicil John A · Huntsville, ALN5937VLeftridge Dustin · Kalispell, MTN5937WMikesell Lloyd L · Kokomo, INN5937ZFurman Maximillian · Barnum, MNN5938LMidland Avionics LLC · Louisville, KYN5938QNeely Eric R · Seagoville, TXN5938ULame Duck Aviation LLC · Leesburg, INN5938WDewald Joseph L · Fort Wayne, INN5939WPhillips Morris · Decatur, GAN593ASwift Harvey G · Clinton, ARN593ACHomelvig John D · Bismarck, NDN593AMSandpiper Aircraft LLC · Wilmington, DEN593CPCivil Air Patrol · Montgomery, ALN593FLEmpire Aviators LLC · Long Island City, NYN593MA2dogs LLC · Dover, DEN593MTMiddle Tennessee State University · Murfreesboro, TNN593NDChristiansen Aviation LLC · Wilmington, DEN593SCSpartan Education LLC · Tulsa, OKN593SPFull Rudder Flyers LLC · Mesa, AZ
Back to AD 81-18-04 R2