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.

N8654APicturesque Aviation LLC · Fort Worth, TXBuilt 1949 · S/N D-2064 N8654QSpitler Cynthia D · Maryville, TNBuilt 1964 · S/N D-7667 N8657APierson Jeffrey L · Montague, MIBuilt 1949 · S/N D-2067 N8657QSchmidt Jack R · Chagrin Falls, OHBuilt 1964 · S/N D-7738 N8658MLoach James A · Omaha, NEBuilt 1963 · S/N D-7259 N8658QHarris Austin K · Enid, OKBuilt 1964 · S/N D-7673 N8659ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1949 · S/N D-2069 N865MCN865mc LLC · Knoxville, TNBuilt 1973 · S/N TE 905 N8661MRoth Richard D · Riverside, CABuilt 1964 · S/N D-7280 N8662AAircraft Partner Holdings Inc Trustee · BerlinS/N D-2127 N8662QGrant Aviation LLC · Cheyenne, WYFirst renewal noticeBuilt 1964 · S/N D-7672 N8665MAppraisal Services Inc · Walters, OKBuilt 1963 · S/N D-7264 N8665QMojo Aerospace LLC · Wilmington, DEBuilt 1964 · S/N D-7676 N8666VFriedman Michael S · Chantilly, VAFirst renewal noticeBuilt 1965 · S/N D-7832 N8667AForthun Daniel Jay · Argyle, TXS/N D2129 N8667QNerstrom James S · Libertyville, ILBuilt 1964 · S/N D-7679 N8668QFrequent Flyers LLC · Kalispell, MTS/N D-7682 N8669ARounds Chris · Waller, TXBuilt 1949 · S/N D-2079 N8669MMayes David K · Lake Ozark, MOBuilt 1963 · S/N D-7269 N8669QCopperhead LLC · Murrieta, CABuilt 1964 · S/N TC-802 N866RAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N EA-105 N8672MN8672m LLC · Newaygo, MIBuilt 1963 · S/N D-7266 N8674QHalasi Kun David L · Suffield, CTBuilt 1964 · S/N D-7683 N8676Fortmann Christopher S · Okarche, OKBuilt 1966 · S/N TC-964 N8677MRegistered aircraftBuilt 1963 · S/N D-7272 N8677QLittle Lady Inc · Wilmington, DEBuilt 1964 · S/N D-7684 N8678QProffitt Perry Vaughn · Roanoke, TXBuilt 1964 · S/N D-7681 N8679QEagle Flight Services LLC · Lake Oswego, ORS/N D-7687 N867DBLimberopoulos Anthony John · Naperville, ILBuilt 1987 · S/N CE-1134 N867LCCurd Layton · Cypress, TXBuilt 1991 · S/N E-2649 N867SSixty Seven Sierra LLC · Wilmington, DEBuilt 1969 · S/N D-8957 N867TDecelles Philip P Trustee · Napa, CABuilt 1964 · S/N TC-759 N8680MFrastaci Jeffrey A · Pioneer, OHS/N D-7291 N8681ACopeland Forrest H · Brentwood, CABuilt 1949 · S/N D-2091 N8682QNoguess Levi B · Belton, TXBuilt 1964 · S/N D-7696 N8683QStar City Flying Carrier LLC · Lincoln, NEBuilt 1964 · S/N TC-810 N8684QBush Mark B · Crosby, TXBuilt 1964 · S/N D-7688 N8686MTrujillo Joe E · Oakland, CABuilt 1963 · S/N D-7275 N8687MMassingale Harold L · Lenoir City, TNS/N D-7277 N8687QWhite Thomas B · Long Beach, CABuilt 1964 · S/N D-7694 N868LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N A-173 N868TPatriot Aviation Logistics LLC · Lewes, DEBuilt 1964 · S/N TC-703 N8690MScruggs Steven C · Astoria, ORBuilt 1964 · S/N D-7279 N8690QWallek Dustin L · Corpus Christi, TXBuilt 1964 · S/N D-7700 N8692ACrouse Wayne A · Bernice, OKBuilt 1949 · S/N D-2200 N8692MBowser Adam L · Lake City, FLBuilt 1963 · S/N D-7288 N8693MLandis Rob R · Seabrook, TXBuilt 1963 · S/N D-7276 N8693QFester John P · Sullivan, MOBuilt 1964 · S/N D-7703 N8694QBonkowski & Associates Inc · Emeryville, CABuilt 1964 · S/N D-7704 N8695MGround Floor Design LLC · Idyllwild, CABuilt 1964 · S/N D-7336

Back to AD 99-05-13 R1 WD