Registered aircraft · 806

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:93-24-02-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:93-24-02-R1') 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:93-24-02-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:93-24-02-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:93-24-02-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:93-24-02-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.

N4910Vizas Global LLC · Grosse Pointe Park, MIBuilt 1977 · S/N 31-7752183 N4938SAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1982 · S/N 31T-8166050 N497WWWin Win Aviation Inc · Wake Forest, NCBuilt 1978 · S/N 31T-7820045 N500HRDese Enterprises LLC · Huntsville, ALBuilt 1981 · S/N 318152133 N500KPPung Michael W DBA · Alma, MIS/N 31-8152094 N504KSJb522 LLC · Pflugerville, TXS/N 31-8012075 N50PSExecutive Airshares LLC · St Thomas, VIBuilt 1973 · S/N 31-7405165 N50RNOn Three Angels Wings LLC · Melbourne, FLBuilt 1983 · S/N 31P-8414013 N511PJNanavati Parashar Jayendra Trustee · Springfield, ILBuilt 1983 · S/N 31T-1104006 N515GAFramalin Leonard · Troy, MIBuilt 1981 · S/N 31T-8104050 N515LGN515lg Holding Inc · Wilmington, DEBuilt 1975 · S/N 31-7652001 N51KMBaker Leasing LLC · Kotzebue, AKBuilt 1973 · S/N 31-7305009 N521JMJmcy Air LLC · Wilmington, DES/N 31T-8004040 N521PMJetset Airmotive Inc · Hialeah, FLBuilt 1977 · S/N 31T-7720048 N523PDRulewiez Dennis G · Jackson, MIBuilt 1979 · S/N 31T-7904044 N524AMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 31T7920039 N524ERGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 31-8152132 N525SWKramme Scott R · Elmer, NJBuilt 1979 · S/N 31T-8020024 N528CHWord Jon D · Albuquerque, NMBuilt 1980 · S/N 31T-8020049 N52HLBaker Mark · Murfreesboro, TNBuilt 1980 · S/N 31T-8004023 N52RCTrager Limestone LLC · Chillicothe, MOS/N 31P-7630003 N52TTMinuteman Aviation Inc · Missoula, MTBuilt 1979 · S/N 31T-7920057 N530JBAir Transport Services Inc · Tarpon Springs, FLS/N 31-7952156 N533YABb Aero Works Ltd · Whitehouse, OHBuilt 1968 · S/N 31-157 N53MCGulf Air Aviation Inc · Wilmington, DEBuilt 1978 · S/N 31T-7820025 N53TAIndiana Paging Network Inc · La Porte, INBuilt 1978 · S/N 31T-7820083 N543133seaslal LLC · Lakeland, FLBuilt 1974 · S/N 31-7405439 N543JCBritshaw LLC · Lansdale, PABuilt 1977 · S/N 31-7752103 N543SBBielder Street Aviation LLC · North Charleston, SCBuilt 1979 · S/N 31-7912034 N545RKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 31T-7720064 N549JBBlue Bird Aviation LLC · Ocean City, MDBuilt 1980 · S/N 31-8052108 N54CLAir Transport Resources · Naperville, ILBuilt 1970 · S/N 31-652 N54WAWright Air Service Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652067 N554KDWestern Air International Co · Pompano Beach, FLBuilt 1979 · S/N 31-7952157 N555FRWallace Jeffrey S · Bonita Springs, FLS/N 31T-8004010 N555FSJacko Josh E · Anchorage, AKBuilt 1978 · S/N 31-7952046 N555GTRegistered aircraftBuilt 1979 · S/N 31-7952148 N555JGLeia Air LLC · Wilmington, DEBuilt 1979 · S/N 31-8012018 N555MFCloud 555 Inc · Wilmington, DEBuilt 1980 · S/N 31-8012068 N55RPneuma Aviation LLC · New Orleans, LABuilt 1976 · S/N 31T-7620055 N565BTGsg Aviation LLC · Fort Lauderdale, FLBuilt 1980 · S/N 31-8052118 N56MHB S Aviation LLC · Stuart, FLBuilt 1979 · S/N 31-7952068 N56MJBishop Ronald Daniel · Port Orange, FLBuilt 1981 · S/N 31-8152108 N56PCValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-8052005 N57539Registration Pending · Meriden, CTRegistration pendingBuilt 1976 · S/N 31P-7630002 N575EHajdukovich Robert M · Fairbanks, AKBuilt 1976 · S/N 31-7652006 N57GPFoncho Corp · San Juan, PRBuilt 1982 · S/N 31-8252043 N596LKcc Aero LLC · Guaynabo, PRBuilt 1977 · S/N 31-7712036 N59752Visionaire Enterprises LLC · Statesville, NCBuilt 1975 · S/N 31-7612010 N59764Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1975 · S/N 31-7652037

Back to AD 93-24-02 R1