Registered aircraft · 2,862

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

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 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 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 N550WJSale Reported · Weston, FLSale reported, pending cancellationBuilt 1972 · S/N 550-0352 N550WMWno Trust Services LLC Trustee · Wilmington, DEBuilt 1992 · S/N 229 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 N551FPSkyway Aviation Services Inc · Palm Harbor, FLBuilt 2003 · S/N 525-0515 N551KAKajapa Air Inc · Vienna, WVBuilt 2000 · S/N 550-0922 N551MLBravo N551ml LLC · Irvine, CABuilt 2001 · S/N 550-0989 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 N552CNRer Plane LLC · San Antonio, TXBuilt 2004 · S/N 560-0674 N552MEN552me LLC · Las Vegas, NVBuilt 2000 · S/N 258459 N553BWHawker 800xp LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258570 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 N554TSS & S Seeds Inc · Carpinteria, CABuilt 1996 · S/N 560-0376 N554VPJl Diversified LLC · Scottsdale, AZBuilt 2001 · S/N 560-0554 N555BGN & E Aviation LLC · Olathe, COS/N 525-0113 N555DSWeather Modification LLC · Fargo, NDBuilt 1981 · S/N 550-0275 N555DWInstitue Of Aeronautical And Aerospace Institute · Aguadilla, PRBuilt 1985 · S/N 459 N555EHHolen Endre · Las Vegas, NVBuilt 1992 · S/N 560-0162 N555HMAirops II LLC · Salinas, CABuilt 2000 · S/N 550-0950

Back to AD 97-05-03 R1