Registered aircraft · 629

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:90-07-10-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:90-07-10-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:90-07-10-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:90-07-10-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:90-07-10-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:90-07-10-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.

N510JCMiller Timber Services Inc · Philomath, ORBuilt 1980 · S/N 550-0197 N511ABSl Jet LLC · Franklin, NCBuilt 1981 · S/N 550-0299 N513WTL L Express LLC · Wilmington, DEBuilt 1987 · S/N 551-0556 N515MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 550-0899 N518MVAzalea Connection LLC · Columbus, OHBuilt 1981 · S/N 551-0046 N518NGtt LLC · Panama City Beach, FLBuilt 1987 · S/N 550-0563 N519RJAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 550-0194 N519VPCatalyst Aviation II LLC · Pensacola, FLBuilt 2002 · S/N 550-1019 N51DACentral Virginia Aviation Inc · Petersburg, VABuilt 1987 · S/N S5500134 N521TMN521tm LLC · Eagle, IDBuilt 1992 · S/N 550-0705 N524XAOn Three Angels Wings LLC · Melbourne, FLBuilt 2001 · S/N 550-0988 N525JANewsome Jeff S · Blackwell, OKBuilt 1981 · S/N 550-0252 N525PEFliteaccess LLC · Louisville, KYBuilt 2002 · S/N 550-1031 N528DXXitp LLC · Newark, DEBuilt 2000 · S/N 550-0906 N52LTBc Aero Holdings LLC · Dover, DEBuilt 1982 · S/N 550-0355 N530CLGilgal Stones Consulting LLC · Flint, TXS/N S550-0094 N531THCrimson Skies LLC · Pelham, ALBuilt 2001 · S/N 5500990 N535MPLouisville Aviation LLC · Louisville, KYS/N 550-0179 N53DDResort Air LLC · Honolulu, HIBuilt 1992 · S/N 550-0711 N53FPDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 550-0434 N544CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 550-0701 N546CGCoulson Aviation USA Inc · Portland, ORBuilt 1991 · S/N 5500686 N547CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1991 · S/N 550-0687 N548CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 550-0700 N549CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 5500699 N54HTBravo V Aviation LLC · Harrisburg, PABuilt 2001 · S/N 550-1001 N550ABAbt Aviation LLC · Bay City, MIBuilt 1990 · S/N 550-0633 N550AJCola Express LLC · Ripley, WVBuilt 1987 · S/N S550-0141 N550AS550 LLC · Kalispell, MTBuilt 1981 · S/N 550-0390 N550BCCb Air LLC · Fayetteville, ARS/N 550-0804 N550BJLybl Air 2 LLC · Portland, ORBuilt 2002 · S/N 550-1029 N550BMMareth Management Inc · Monett, MOBuilt 1979 · S/N 550-0117 N550CFMidwest Jet LLC · Marshall, MNBuilt 1991 · S/N 550-0669 N550CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1991 · S/N 550-0677 N550CTGroup Two LLC · North Dinwiddie, VABuilt 1978 · S/N 5500033 N550CZMldg Aviation LLC · Warden, WABuilt 1987 · S/N S550-0128 N550DLMmch Aerospace LLC · Goshen, INBuilt 1988 · S/N S550-0155 N550DSMetro Aviation Inc · Shreveport, LABuilt 1988 · S/N S550-0154 N550FPJk Aircraft Options LLC · Aripeka, FLBuilt 1983 · S/N 550-0468 N550GZFlybynight LLC · Imperial, CABuilt 1979 · S/N 5500092 N550HCVasquez Jimmy · Carlsbad, NMBuilt 1986 · S/N S550-0116 N550HHGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1997 · S/N 550-0802 N550HJBravo II LLC · Carmel, INS/N 550-1117 N550HKGlass City Leasing LLC · Perrysburg, OHS/N 550-0816 N550JMayes John · Carson City, NVBuilt 1998 · S/N 550-0848 N550JXN918vc Corp · Wilmington, DEBuilt 1987 · S/N 550-0557 N550MJMidwest Jet LLC · Lynd, MNBuilt 1981 · S/N 550-0215 N550MLDjp Properties LLC · Selma, CABuilt 2004 · S/N 550-1082 N550MNBarkley Air LLC · Scottsboro, ALS/N 550-0069 N550MZN550mz LLC · Omaha, NEBuilt 2004 · S/N 550-1075

Back to AD 90-07-10 R1