AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N5705LKing William C · Huntington Beach, CAN5705QBlack 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, CAN5709UGundersen Lance · Murfreesboro, TNN5709WBrinkley Ralph L · Lexington, NCN5709ZBettilyon Walter S · Shady Shores, TXN570CAMidwest Aviation Inc · Mayfield, KYN570MATuminello Joseph A · San Francisco, CAN570MTMiddle Tennessee State University · Murfreesboro, TNN570PUPurdue University Trustees · West Lafayette, INN570RVBell Arthur M · Parkville, MDN570SCSpartan Education LLC · Tulsa, OKN570SPOne Seventy To Delta LLC · Scottsdale, AZN570TFAir Fleet Holdings LLC · Missoula, MTN570UOhio University · Albany, OHN5710Tato Hauling Services LLC · Middletown, DEN5710FOso Air LLC · Missoula, MTN5710QHopper Ronald W · Thousand Oaks, CAN5710WOso Air LLC · Missoula, MTN5710ZSpangler David G · New Richmond, WIN5711DEastin Toby M · Jefferson City, MON5711FVoelker Steve L · Clackamas, ORN5711UBlack Cat Aviation Inc · Wilmington, DEN57120Bellows Paul F · Vancouver, WAN5712DLo Jeffrey G · San Jose, CAN5712FPhil Birkelbach · Waller, TXN5712QChambliss Walton Aviation Enterprises LLC · Greer, SCN5712UPark Hui Nam · Buena Park, CAN5712ZVollmerhausen Otto J · Bethpage, NYN5713FDufresne Justin B · San Tan Valley, AZN5714DAnte George Sherman Jr · Eagle River, AKN5714FRegistration Pending · Arlington, TXRegistration pendingN5714HThomsen Michael · Pleasanton, CAN5714UTxl Consulting LLC · Hurst, TXN5715DScootair LLC · Alburgh, VT
Back to AD 90-04-06 R1