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.

N226PCWhite Oak Flight Service Inc · Beckley, WVBuilt 1998 · S/N 550-0835 N229BMCessna Aircraft Leasing LLC · Daytona Beach, FLS/N 5500207 N22GFBravo Sz LLC · Alpharetta, GAS/N 550-1077 N22GRM/V Forger Inc · Salem, ORBuilt 1999 · S/N 550-0892 N22JAJet Air Inc · Iowa City, IAS/N 550-1129 N22PCFlying Falcons LLC · Wilmington, DEBuilt 1988 · S/N 550-0583 N237WCMiro Aviation Holdings LLC · Coral Gables, FLBuilt 1980 · S/N 550-0129 N238EJFisher Elizabeth J · Odessa, TXBuilt 1997 · S/N 550-0812 N238JPJjk Acquisitions LLC · Kerman, CABuilt 2002 · S/N 550-1024 N23YCZip-O Aviation LLC · Eugene, ORBuilt 2000 · S/N 550-0923 N241DSNcb Air Ventures LLC · Lighthouse Point, FLS/N S550-0042 N247AJCarpe Diem 247 LLC · Evansville, INBuilt 2002 · S/N 550-1006 N247JMAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 550-0272 N24EWarrior Aviation LLC · Brookwood, ALBuilt 1990 · S/N 550-0651 N255TCLandhawk Aviation LLC · Lewes, DEBuilt 1990 · S/N 550-0638 N256CPSkymax Aero LLC · Chantilly, VAS/N S550-0033 N257BWGb Aviation Leasing LLC · Mooresville, NCBuilt 1981 · S/N 5500283 N25FSBbjs Investments LLC · Waukesha, WIBuilt 1997 · S/N 550-0823 N25GZTvpx Aircraft Soultions Trustee · North Salt Lake, UTS/N S550-0011 N263WC24-7 Machinery LLC · Ponca City, OKBuilt 2000 · S/N 550-0944 N26496Cypress Aircraft Sales LLC · Clermont, FLS/N 550-0607 N26APMillennium International LLC · Lees Summit, MOBuilt 1997 · S/N 550-0824 N26HGNion LLC · New Century, KSBuilt 1989 · S/N 551-0614 N26HHApa Aviation LLC · Gainesville, FLBuilt 1981 · S/N 550-0316 N271SBVillains Airways LLC · Newark, DEBuilt 2000 · S/N 550-0940 N27TBBos Dairies LLC · Lake Havasu City, AZS/N S550-0082 N280PMCommand Decisions Inc · San Angelo, TXBuilt 1980 · S/N 5500188 N283DFTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1983 · S/N 5500456 N285MCCypress Aviation LLC · Lyon, MSBuilt 1986 · S/N S550-0102 N28LALv Air LLC · Lompoc, CABuilt 1980 · S/N 550-0200 N299RKGasser LLC · Midland, TXBuilt 2002 · S/N 550-1027 N2GQ6 Echo November LLC · Murfreesboro, TNBuilt 1981 · S/N 550-0286 N300GCN300gc LLC · Los Angeles, CABuilt 1981 · S/N 550-0311 N302SJSendero Aviation LLC · Houston, TXBuilt 1979 · S/N 550-0052 N305ZPLewis Aviation LLC · Baton Rouge, LABuilt 1997 · S/N 550-0819 N308DTTippmann Industrial Products Inc · Fort Wayne, INBuilt 2004 · S/N 550-1094 N308GLN308gl LLC · Fort Worth, TXBuilt 1985 · S/N S550-0036 N308TWCentral Connecticut Aircraft LLC · Plainville, CTBuilt 1979 · S/N 550-0044 N30AVExtraordinaire Aviation LLC · Fairfield, OHS/N 550-0026 N30GRGreat Ride LLC · Meridian, MSS/N 550-0656 N30RLRomeo Tango Aviation LLC · Rockford, ALBuilt 1990 · S/N 550-0653 N3116TOrion Aerial LLC · Reno, NVBuilt 1983 · S/N 550-0471 N311CSCtw Holdings LLC · Friendswood, TXBuilt 2001 · S/N 550-0979 N312GSGolden Shamrock Associates LLC · North Platte, NEBuilt 1999 · S/N 550-0890 N312NCDiva Air LLC · Bloomfield Hills, MIBuilt 1981 · S/N 550-0290 N318GLFamily Air LLC · Louisville, KYBuilt 2003 · S/N 550-1060 N322GTInde Aero LLC · Chandler, AZS/N 550-1030 N322MAN322ma LLC · Reno, NVBuilt 1982 · S/N 551-0378 N323EBOzark Air LLC · Prairie Grove, ARBuilt 1999 · S/N 550-0893 N323JRS550 LLC · Breaux Bridge, LABuilt 1987 · S/N S550-0129

Back to AD 90-07-10 R1