Registered aircraft · 13,518

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

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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') ORDER BY n_number

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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:99-05-13-R1-WD')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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.

N993MDBoyd Aviation LLC · Lakeville, MNBuilt 1984 · S/N CE1029 N993QTangen Arthur · Albuquerque, NMBuilt 1961 · S/N D-6873 N993TBeyond Approach LLC · Brighton, COBuilt 1964 · S/N D-7414 N9949RJeca Flight LLC · Liberal, KSBuilt 1960 · S/N TD-388 N994QLooney Hubert · Florissant, MOBuilt 1961 · S/N D-6817 N994RFFlagg Randall P · Southwick, MABuilt 1959 · S/N D-6017 N994SGardner Adam P · Morrisville, NCBuilt 1957 · S/N D5180 N994WYInternational Air Services Inc Trustee · Carson City, NVS/N TE-1001 N9955RWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTS/N TD-426 N9956RMiga Holdings LLC · Flower Mound, TXBuilt 1960 · S/N TD-394 N995EGEagle Group USA Inc · Howell, MIBuilt 1980 · S/N EA-90 N995FMHalcyon Vineyards LLC · Sonoita, AZS/N D-5477 N995QMetzger Jordan · San Diego, CABuilt 1961 · S/N D-6816 N9961RQuinn Brian K · Labelle, FLBuilt 1960 · S/N TC-2 N9968PFlax Brian J · Germantown, TNBuilt 1997 · S/N E-3109 N996FInloes Mechanical Utah LLC · Ogden, UTBuilt 1996 · S/N E-3042 N996JKFletcher Flying Service 419 LLC · Labelle, FLBuilt 1996 · S/N E-3051 N996VWakeman Donald H · Hanover, NHBuilt 1980 · S/N E-1654 N9972RMerfeld Thomas J · Clive, IABuilt 1960 · S/N D-6485 N9978RButts James A · Gainesville, GABuilt 1960 · S/N TD-415 N99799Vocell James J · Moultonborough, NHBuilt 1969 · S/N BA-758 N997BBBlankenship John R · Weirsdale, FLBuilt 1980 · S/N D-10328 N997BC997bc LLC · Roseburg, ORS/N D-7761 N997JS & C Aero LLC · Collierville, TNBuilt 1974 · S/N CE-498 N997JHMedical Staffing Support LLC · Williamstown, WVBuilt 1980 · S/N TC-2355 N99800Rugged Investments One LLC · North Miami, FLBuilt 1969 · S/N BA-759 N9981RMatthias Robert C · Gainesville, FLBuilt 1960 · S/N TD-419 N9984RMoloney Phillip M · Lexington, KYS/N TD-420 N9988RSanders Flight Training Center Inc · Jasper, ALBuilt 1960 · S/N TD-407 N998BBWw Aero LLC · Jonesboro, ARBuilt 1983 · S/N E-2113 N998DMD & S Aviation LLC · Spring, TXBuilt 1967 · S/N TD-697 N998JGDragonfly Aviation LLC · Davie, FLBuilt 1999 · S/N EA-641 N998LSTalton Rentals LLC · Tupelo, MSBuilt 1998 · S/N E-3204 N998LTBfh Management LLC · Fernandina Beach, FLBuilt 1960 · S/N D-6293 N998PLStormy Aviation LLC · Fargo, NDBuilt 1996 · S/N E-3036 N998PMWirth Aviation LLC · Scottsdale, AZBuilt 1999 · S/N E-3251 N99910Roof Management Ltd · Marysville, OHBuilt 1975 · S/N D-9767 N99914Roof Management Ltd · Marysville, OHBuilt 1970 · S/N D-9178 N9993Pro Team Aviation LLC · Jonesboro, ARBuilt 1970 · S/N D-9175 N9994RPower Shane M · Parker, COS/N D-6480 N9995RBig Sky Navigation & Flight Training LLC · Bristol, VABuilt 1961 · S/N TD-465 N9996RMitchell Myron · Advance, NCBuilt 1960 · S/N D-6483 N9998RSkyview Aviation LLC · Benton, KYBuilt 1960 · S/N TD-428 N999AJNedley Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 1984 · S/N EA-417 N999BBGoode Stephen C · Canton, TXS/N D-5630 N999BCCcc Aviation LLC · Havre, MTBuilt 1965 · S/N D-7836 N999BFRigel Aviation Inc · Jefferson Hills, PABuilt 1979 · S/N EA-24 N999CECb Wings LLC · Eugene, ORBuilt 1980 · S/N EA-86 N999DPRobinson Aviation Holdings LLC · Houston, TXBuilt 1971 · S/N D-9263 N999EMOombu LLC · Round Rock, TXBuilt 1964 · S/N M-552

Back to AD 99-05-13 R1 WD