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.

N42PHOrion Aerial LLC · Reno, NVBuilt 1981 · S/N 550-0304 N431MSTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1987 · S/N S5500127 N432RJWings LLC · Homewood, ALBuilt 2001 · S/N 550-0967 N439SErie Aviation LLC · Salem, ORBuilt 1993 · S/N 5500718 N43BEComputer Service Professionals Inc DBA · Wilmington, DEBuilt 1979 · S/N 551-0149 N43VSV1vr LLC · Wilmington, DEBuilt 1985 · S/N S550-0069 N440SErie Aviation LLC · Salem, ORBuilt 1991 · S/N 550-0692 N444EAMoongate LLC · Newark, DEBuilt 2004 · S/N 550-1079 N444GFuquay Inc · New Braunfels, TXBuilt 1980 · S/N 550-0209 N446SHAims Community College · Greeley, COBuilt 1982 · S/N 550-0341 N447SFSeneca Foods Corp · Penn Yan, NYBuilt 2002 · S/N 550-1020 N44FRArkansas Jet Sales & Leasing LLC · Gulf Shores, ALBuilt 1981 · S/N 550-0334 N451DABrown Lawson M II DBA · San Diego, CABuilt 1979 · S/N 5510141 N453SMeanr LLC · Cleveland, OHBuilt 1982 · S/N 550-0445 N456TX2141 Corp · Wilmington, DEBuilt 1980 · S/N 5500249 N459MDMosaic Leasing II LLC · Salem, ORBuilt 1991 · S/N 550-0685 N459TJJohn R Lawson Rock & Oil Inc · Fresno, CABuilt 1981 · S/N 550-0308 N45FSBristol Air LLC · Monte Vista, COS/N 5500562 N45MLFarwest Aviation LLC · Billings, MTS/N 550-0367 N466SGSao Enterprises LLC · Omaha, NEBuilt 1991 · S/N 550-0695 N469DEIndy Bravo LLC · Carmel, INBuilt 1999 · S/N 550-0883 N475HCPj Company LLC · New Braunfels, TXBuilt 1983 · S/N 550-0475 N476LCL-3 Is LLC · Kalispell, MTBuilt 1986 · S/N S550-0091 N476RSK & M Industrial LLC · Gladstone, MIBuilt 1982 · S/N 550-0441 N477LCPremier Aircraft Trading Service Inc · Lewes, DEBuilt 1988 · S/N S550-0153 N47NMMooch Aire LLC · Anchorage, AKBuilt 2005 · S/N 550-1112 N488SBJ&P Aviation LLC · Jasper, ALS/N 550-1026 N48BVTrn Aviation LLC · Lewes, DEBuilt 1985 · S/N S550-0032 N48FWLucas Oil Products DBA Lucas Cattle Co · Indianapolis, INBuilt 2000 · S/N 550-0948 N48KHAirshair LLC · Oak Creek, WIBuilt 1981 · S/N 550-0295 N494GPAerotrust Services Corp Trustee · Wilmington, DEBuilt 1990 · S/N 550-0627 N495CMAbove & Beyond Aviation Inc · Anchorage, AKBuilt 1980 · S/N 550-0151 N497PFBravo Air LLC · Sellersburg, INBuilt 2000 · S/N 550-0964 N499EMPhysicians Air Transport LLC · Hot Springs, ARBuilt 1999 · S/N 550-0869 N499RCCentral Virginia Aviation Inc · Petersburg, VAS/N S550-0090 N49KWJet Air Inc · Iowa City, IABuilt 2002 · S/N 550-1021 N49UN49u LLC · Forest, VABuilt 1979 · S/N 550-0082 N4ATGifford David K · Newton, MABuilt 1997 · S/N 550-0805 N500ZBFregata Systems LLC · Saint Louis, MOBuilt 1985 · S/N S550-0023 N501BZN501bz LLC · Boca Raton, FLBuilt 1987 · S/N S550-0144 N501GGN501gg LLC · Pasco, WABuilt 1983 · S/N 550-0484 N505MSCessna Aircraft Leasing LLC · Daytona Beach, FLS/N 550-0601 N506PDDodson International Parts Inc · Rantoul, KSS/N 550-1084 N507ECSiilats Keith Trustee · New York, NYS/N 5500143 N509RPRonald A Peterson Inc DBA · Orlando, FLS/N S550-0030 N50NBLexington Air Services LLC · Lexington, MSBuilt 1984 · S/N S550-0022 N50VSCitation Time LLC · Seguin, TXBuilt 1980 · S/N 550-0181 N50WRfbc LLC · Macon, GAS/N 550-0884 N510CNC & N Aviation LLC · Coshocton, OHBuilt 2006 · S/N 550-1124 N510GPCentral Virginia Aviation Inc · Petersburg, VABuilt 1982 · S/N 550-0421

Back to AD 90-07-10 R1