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.
N5704UZephyr Air LLC · Hickory, NCN5704ZSmalbergher Dorin · Soldiers Grove, WIN5705DBirdwell Brett M · Lewistown, MTN5705FWilkinson David E · Waleska, GAN5705HHangar 13 LLC · Winchester, VAN5705LKing William C · Huntington Beach, CAN5705PN5705p Inc · Pompano Beach, FLN5705QBlack David W Trustee · Redding, CAN5705WSmart Avionics Inc · Marietta, PAN5706DReese Lonnie E · Talking Rock, GAN5706HWhitlock Paul H · Kent, WAN5706PAldredge J Ralph · Milner, GAN5706QKnox James · Perryton, TXN5706USaccento Anthony J · Binghamton, NYN5706WShick Andrew C · Grand Junction, CON5707FEure Michael T · Moyock, NCN5707HMooney Timothy · Hedgesville, WVN5708HGodec David E · Waunakee, WIN5708JNelson Kevin B · Aledo, TXN5708QLowry Gregory A · Beaufort, SCN5708UFwj Aviation LLC · Crown Point, INN5708ZSantee Steven J · Ellendale, MNN5709FBitterfield Colin · Las Vegas, NVN5709HSmith Zac A · Mill Valley, CAN5709PSaadjack LLC · Amelia Island, FLN5709UGundersen Lance · Murfreesboro, TNN5709WBrinkley Ralph L · Lexington, NCN5709ZBettilyon Walter S · Shady Shores, TXN570BNHyannis Air Service Inc · Hyannis, MAN570CAMidwest Aviation Inc · Mayfield, KYN570DBAtlas Aviation Tampa Inc · Tampa, FLN570FGRidgeline Assets LLC · Wilmington, DEN570HRegistered aircraftN570JAJ A Flight Services LLC · Sugar Grove, ILN570MATuminello Joseph A · San Francisco, CAN570MTMiddle Tennessee State University · Murfreesboro, TNN570NDAerosim Academy Inc · Sanford, FLN570PUPurdue University Trustees · West Lafayette, INN570RVBell Arthur M · Parkville, MDN570SRobinson Michael D · Folkston, GAN570SCSpartan Education LLC · Tulsa, OKN570SPOne Seventy To Delta LLC · Scottsdale, AZN570TCCook Timothy · Byrdstown, TNN570TFAir Fleet Holdings LLC · Missoula, MTN570UOhio University · Albany, OHN570WHMf Helicopters LLC · East Troy, WIN5710FOso Air LLC · Missoula, MTN5710QHopper Ronald W · Thousand Oaks, CAN5710WOso Air LLC · Missoula, MTN5710ZSpangler David G · New Richmond, WI
Back to AD 81-18-04 R2