Skip to content

Registered aircraft · 94

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:88-13-03-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:88-13-03-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:88-13-03-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:88-13-03-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:88-13-03-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:88-13-03-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.

N123FFN123ff LLC · North Palm Beach, FLS/N S550-0005 N123TLN919cs LLC · Colts Neck, NJBuilt 1987 · S/N S550-0124 N163JN163j LLC · Smithfield, NCBuilt 1987 · S/N S550-0122 N16RPRose Aviation LLC · Sarasota, FLBuilt 1985 · S/N S5500047 N178DAAr Leasing LLC · Portland, ORBuilt 1984 · S/N S550-0004 N17LPN17lp LLC · Amarillo, TXBuilt 1985 · S/N S550-0111 N181GMid South Agricultural Products Inc · Lafayette, LAS/N S550-0006 N220BPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N S550-0034 N224KCBeasley Timber Co In · Hazlehurst, GABuilt 1985 · S/N S550-0104 N241DSNcb Air Ventures LLC · Lighthouse Point, FLS/N S550-0042 N256CPSkymax Aero LLC · Chantilly, VAS/N S550-0033 N25GZTvpx Aircraft Soultions Trustee · North Salt Lake, UTS/N S550-0011 N27TBBos Dairies LLC · Lake Havasu City, AZS/N S550-0082 N285MCCypress Aviation LLC · Lyon, MSBuilt 1986 · S/N S550-0102 N308GLN308gl LLC · Fort Worth, TXBuilt 1985 · S/N S550-0036 N323JRS550 LLC · Breaux Bridge, LABuilt 1987 · S/N S550-0129 N33610Gibson Aviation LLC · Palacios, TXBuilt 1985 · S/N S550-0026 N3489Vspa Citation Holdings LLC · Davie, FLBuilt 1985 · S/N S550-0055 N393EHarvest International Ministries Inc · Texarkana, ARBuilt 1985 · S/N S550-0053 N401HTTailwinds LLC · Houston, TXBuilt 1986 · S/N S5500115 N406CTCentral Virginia Aviation Inc · Petersburg, VABuilt 1985 · S/N S550-0038 N413CTEagle LLC · Missoula, MTBuilt 1985 · S/N S550-0017 N431MSTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1987 · S/N S5500127 N43VSV1vr LLC · Wilmington, DEBuilt 1985 · S/N S550-0069 N476LCL-3 Is LLC · Kalispell, MTBuilt 1986 · S/N S550-0091 N477LCPremier Aircraft Trading Service Inc · Lewes, DEBuilt 1988 · S/N S550-0153 N48BVTrn Aviation LLC · Lewes, DEBuilt 1985 · S/N S550-0032 N499RCCentral Virginia Aviation Inc · Petersburg, VAS/N S550-0090 N500ZBFregata Systems LLC · Saint Louis, MOBuilt 1985 · S/N S550-0023 N501BZN501bz LLC · Boca Raton, FLBuilt 1987 · S/N S550-0144 N509RPRonald A Peterson Inc DBA · Orlando, FLS/N S550-0030 N50NBLexington Air Services LLC · Lexington, MSBuilt 1984 · S/N S550-0022 N51DACentral Virginia Aviation Inc · Petersburg, VABuilt 1987 · S/N S5500134 N530CLGilgal Stones Consulting LLC · Flint, TXS/N S550-0094 N550AJCola Express LLC · Ripley, WVBuilt 1987 · S/N S550-0141 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 N550HCVasquez Jimmy · Carlsbad, NMBuilt 1986 · S/N S550-0116 N550SGNunya LLC · Irvine, CABuilt 1985 · S/N S550-0070 N550WDWoodbine Aviation LLC · Lewes, DEBuilt 1986 · S/N S550-0110 N550WEInformation Alpha LLC · St Thomas, VIBuilt 1988 · S/N S5500148 N550WKLegacy Jets LLC · Francesville, INBuilt 1985 · S/N S550-0029 N552CJWolf Pack 7 LLC · Wilmington, DEBuilt 1988 · S/N S550-0150 N557CSRabbit Hill Industries Inc · Bedford, NYBuilt 1984 · S/N S550-0016 N575SGOsage Aviation LLC · Yates Center, KSBuilt 1985 · S/N S550-0064 N578GGN578gg LLC · Amarillo, TXBuilt 1985 · S/N S550-0079 N57BJPlukair Delaware LLC · Wilmington, DES/N S550-0052 N598KWRegistered aircraftS/N S550-0098 N600EAEstancia Aviation LLC · Reno, NVBuilt 1985 · S/N S5500015

Back to AD 88-13-03 R1