OpenAirDocs.org
AD 94-05-05 R1

Registered aircraft · 26,230

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:94-05-05-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:94-05-05-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.

N140PDCoulouris George L · Washington, DCBuilt 1950 · S/N 15414N140PRBlue Sky Air LLC · Queen Creek, AZBuilt 1946 · S/N 9440N140RWTarara Chad L · Webster, MNBuilt 1973 · S/N 15074478N140SGGault Scott J · Norcross, GABuilt 1946 · S/N 11573N140SKRon Alexander Youth Aviation Program · Williamson, GABuilt 1947 · S/N 12835N140TGRounds Chris · Waller, TXBuilt 1946 · S/N 9433N140TWRegistration Pending · Burlington, NCRegistration pending, pending cancellationBuilt 1947 · S/N 12403N140WYWilson J Brent Trustee · Lander, WYBuilt 1947 · S/N 12865N140XRegistration Pending · Scottsbluff, NERegistration pendingS/N 11387N140YABeineke Paul R · Marion, OHBuilt 1946 · S/N 10993N1410DMahaffey James P · Grand Prairie, TXBuilt 1951 · S/N 19993N1410GSierra-Mike LLC · Springdale, ARS/N 15073205N1410HCramer Justin R · Eagle River, AKBuilt 1949 · S/N 15AC-462N1410YMolohan Ronald M · Elk Grove, CABuilt 1961 · S/N 17249110N1411BBowen Haldor S · Sandpoint, IDBuilt 1948 · S/N 6038N1411FKrause Alex D II · Clintonville, WIBuilt 1966 · S/N 17254906N1412DKing Matthew W · Wilmington, NCBuilt 1951 · S/N 19995N1412QOconnor Melanie Faith · Flagler Beach, FLBuilt 1971 · S/N 15072712N1413EHeinke Nils A · Elkins, WVBuilt 1946 · S/N 7AC-4976N1413FWitmer Brendle D · Woodbury, PABuilt 1966 · S/N 17254908N1413HBloomfield Management Inc · Dodgeville, WIBuilt 1949 · S/N 15AC-433N1413QWolf John C · Bethel, PABuilt 1971 · S/N 15072713N1413YSooter Craig A · Sedgwick, KSBuilt 1961 · S/N 17249113N1414Frick Gary A Trustee · Marion, INBuilt 1946 · S/N 16604N1414BWatson Bobby M · Hoxie, ARBuilt 1948 · S/N 6041N1414FPalmer Matthew B · Riverside, CABuilt 1966 · S/N 17254909N1414HSardella Jeff · Knoxville, TNS/N 15AC470N1414QForsman Robert J · Jber, AKBuilt 1971 · S/N 15072714N1415DMurphy James S · Skaneateles, NYBuilt 1951 · S/N 20131N1415HGullickson Gregory D · Anchorage, AKBuilt 1949 · S/N 15AC-471N1416BGould Aaron J · Aptos, CABuilt 1948 · S/N 6042N1416YOrefice Anthony C · Clio, MIBuilt 1961 · S/N 17249116N1417HHoag Michael R · Three Rivers, MIBuilt 1949 · S/N 15AC-475N1417QSteinke William A · Mount Juliet, TNBuilt 1971 · S/N 15072717N1418BGrewell Ronald V · West Carrollton, OHBuilt 1948 · S/N 6045N1418DScheer R Michael · Wilmington, NYBuilt 1951 · S/N 20001N1418HErickson Richard F · Wasilla, AKS/N 15AC-478N1418ZHinrichs Gary W · Coos Bay, ORS/N P2002N14193Ward Robert I · Coopersburg, PABuilt 1972 · S/N 7421945N1419BHattan John A · Goddard, KSBuilt 1948 · S/N 6046N1419NTunnell Ga Jr · Dallas, TXRegistration revokedBuilt 1947 · S/N 22947N141CBColeman Charles · Portland, ORBuilt 1999 · S/N 001N141JAVan Ovost Jacqueline · Fort Pierce, FLBuilt 1958 · S/N 55224N141SRennick Wallace W · Butterfield, MNS/N 141N141TEB-N-K2 LLC · Reserve, LABuilt 1946 · S/N 17311N1420BWeber Joel A · Goddard, KSBuilt 1948 · S/N 6047N1420FGaither John A · Rumsey, KYBuilt 1966 · S/N 17254915N1420HWagner James M Trustee · Reno, NVS/N 15AC-477N1420QSweet Sanford L · Tawas City, MIS/N 15072720N1422HNedley A Lloyd · Birmingham, MIRegistration revokedBuilt 1950 · S/N 15AC484
Back to AD 94-05-05 R1