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.

N550NBSkies The Limit LLC · Raleigh, NCBuilt 1981 · S/N 550-0396 N550NTAllied Asset Management LLC · Oklahoma City, OKBuilt 1980 · S/N 5500123 N550PFExecutive Business Travel LLC · Wilmington, DEBuilt 1982 · S/N 550-0428 N550RBUrban Wings LLC · San Antonio, TXBuilt 2001 · S/N 550-0971 N550RMReal X Jet LLC · Sarasota, FLBuilt 2005 · S/N 550-1099 N550RZN550rz LLC · Saint James City, FLBuilt 1997 · S/N 5500817 N550SCX Air Flight Support LLC · Uvalde, TXBuilt 1991 · S/N 5500691 N550SFN550sf LLC · Nashville, TNBuilt 1979 · S/N 550-0110 N550SGNunya LLC · Irvine, CABuilt 1985 · S/N S550-0070 N550SKAfp Travel LLC · Waco, TXBuilt 2001 · S/N 550-0999 N550SSHorgan Enterprises LLC · Newport Beach, CABuilt 1979 · S/N 550-0084 N550TNTruenorth Companies Lc · Cedar Rapids, IABuilt 2001 · S/N 550-0968 N550TRSpringfield Air Inc · Kansas City, MOS/N 550-0269 N550TWJoveros Aviation LLC · Wilmington, DEBuilt 1989 · S/N 550-0603 N550TYMidwest Jet LLC · Marshall, MNBuilt 1982 · S/N 5500344 N550VGJ Industries LLC · Lewes, DEBuilt 2001 · S/N 5500994 N550WDWoodbine Aviation LLC · Lewes, DEBuilt 1986 · S/N S550-0110 N550WEInformation Alpha LLC · St Thomas, VIBuilt 1988 · S/N S5500148 N550WJSale Reported · Weston, FLSale reported, pending cancellationBuilt 1972 · S/N 550-0352 N550WKLegacy Jets LLC · Francesville, INBuilt 1985 · S/N S550-0029 N550WRN550wr LLC · Lawton, OKBuilt 1983 · S/N 550-0482 N550WSFlores Enterprises 22 LLC · Weslaco, TXBuilt 1998 · S/N 550-0845 N550WTTwined LLC · Hendersonville, TNBuilt 1989 · S/N 550-0599 N550ZSLh Jet Aviation LLC · Honey Brook, PABuilt 1980 · S/N 550-0279 N551BCRadar Rider LLC · Kissimmee, FLBuilt 1979 · S/N 550-0242 N551CZBrig Air 2 LLC · Birmingham, MIBuilt 1978 · S/N 550-0028 N551DAAerotrust Services Corp Trustee · Wilmington, DES/N 550-0025 N551GENw Miles Air LLC · Tualatin, ORBuilt 1980 · S/N 551-0181 N551GFJ M Malone & Son Inc · Carlisle, ARBuilt 1981 · S/N 551-0039 N551HHGem Air LLC · Bakersfield, CABuilt 1978 · S/N 551-0071 N551JKJk Aircraft Options LLC · Aripeka, FLS/N 551-0031 N551KAKajapa Air Inc · Vienna, WVBuilt 2000 · S/N 550-0922 N551LSMixed Wing LLC · Wilmington, DEBuilt 1981 · S/N 551-0369 N551MLBravo N551ml LLC · Irvine, CABuilt 2001 · S/N 550-0989 N551MWHotzler Terry A · Windom, MNBuilt 1979 · S/N 5510132 N551NCNion LLC · New Century, KSBuilt 1950 · S/N 5510171 N551SJFav Tailwind LLC · Arroyo Grande, CABuilt 1980 · S/N 5510205 N551TGLake Vista Aeronautics LLC · Lewes, DEBuilt 1988 · S/N 551-0591 N551THInab LLC · Portland, ORBuilt 2005 · S/N 550-1108 N551TKTkl Equipment LLC · Owasso, OKBuilt 2005 · S/N 550-1101 N551WLPepin Enterprises LLC · Lewes, DES/N 5500261 N551ZD501zd LLC · Palm Coast, FLBuilt 2000 · S/N 550-0903 N552BGRegistration Pending · Suffolk, VARegistration pendingBuilt 1982 · S/N 550-0401 N552CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1991 · S/N 550-0659 N552CJWolf Pack 7 LLC · Wilmington, DEBuilt 1988 · S/N S550-0150 N553MJRat Pack LLC · Panama City, FLBuilt 1987 · S/N 550-0553 N554CGCoulson Aviation (USA) Inc · Portland, ORBuilt 1992 · S/N 550-0680 N554GRTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1988 · S/N 5500292 N554TT & T Enterprises LLC · Santa Clara, CABuilt 2005 · S/N 550-1100 N555DSWeather Modification LLC · Fargo, NDBuilt 1981 · S/N 550-0275

Back to AD 90-07-10 R1