AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N7397SRaynor Rhett A · Dunn, NCN7398EGriffith John M · Seatac, WAN7398SWilson Todd C · Camp Verde, AZN7399ETenney Curtis J · Sevierville, TNN7399QStc Group LLC · Westlake Village, CAN739BSDooley James M Jr · Ashland, VAN739CBRoberts Bryce · Bedford, WYN739CLTower Ty LLC · Calhan, CON739CPCivil Air Patrol · Maxwell Afb, ALN739DMShorten Craig · Atlanta, MON739JGLfw Investments LLC · Hillsborough, NCN739VFGriffin Michael J Trustee · Chesterfield, MON739ZRJw Horton Aviation LLC · Rogers, ARN73BTDragging Tails LLC · Colbert, GAN73CQHillesheim Steven T · Grass Valley, CAN73CYRti Fabrication Inc · Plains, MTN73DAFlying Alaska LLC · Anchorage, AKN73ESWilmington Trust Co Trustee · Wilmington, DEN73GJSkydive Greene County Inc · Xenia, OHN73GLG & N Enterprises LLC · Sparks, NVN73GMPrice Roger Paul · Punta Gorda, FLN73LLT3 Aviation LLC · Oak Point, TXN73LT302 LLC · Anchorage, AKN73MRMarshall Edward G Trustee · Saint Clair, MIN73PRegistered aircraftN73RBTurbo Centurion LLC · North Salt Lake, UTN73SC73sc Owners Group Inc · Torrance, CAN73TAWorks Design Group Inc · Hammondsport, NYN73TLTeaff Leslie T Trustee · Russellville, ARN73TPTop Aircraft Leasing LLC · Wilmington, DEN740United States Department Of Interior · Boise, IDN7401ECosta Air Service LLC · Painted Post, NYN74022Braatz Cannonf · Bend, ORN7402QRichs Alaskan Flying Adventures LLC · Wasilla, AKN7403WJohnston Aircraft Leasing LLC · Highland, CAN7404NFmy Aviationllc · Fort Myers, FLN7409EDavis Julius E · Theodore, ALN740BBellas Business LLC · Kalispell, MTN740BHHarris Jaqai · Juneau, AKN740CPCivil Air Patrol · Maxwell Afb, ALN7410EFerguson Thomas H · Springfield, MON7411ERenshaw Elliott · Lavernia, TXN7412ELorraine Aviation LLC · Lewes, DEN7412QTrostad Kari L · Minnetrista, MNN7412SClear Blue Aviation LLC · Hayden, IDN7413QMccullough Alfonzo F · Aurora, CON7416QRobin Alan Olmstead · Yuma, AZN741CPCivil Air Patrol · Maxwell Afb, ALN741MWatts Scott E · Auke Bay, AKN74206Chinn Larry · Anatone, WA
Back to AD 84-10-01 R1