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.

N605JYN524ma Inc · Wilmington, DEBuilt 1978 · S/N 550-0029 N607JYAlvarez Jorge · Miami Springs, FLBuilt 1980 · S/N 550-0223 N609MTValiair Lc Trustee · Casper, WYS/N S550-0123 N60FTSuper II LLC · Austin, TXBuilt 1983 · S/N 550-0470 N612VRWorldwide Option LLC · Lewes, DEBuilt 1979 · S/N 551-0026 N614AJFoyt Aviation LLC · Waller, TXBuilt 1991 · S/N 550-0588 N614CPInternational Aircraft Marketing & Sales LLC · Sarasota, FLBuilt 1978 · S/N 551-0027 N614JKUniversal Pacific Investment Corp · Portland, ORBuilt 1984 · S/N S550-0018 N616TGYucaipa Aviation Inc · Alvarado, TXBuilt 1986 · S/N S550-0119 N618LKRvr Air Charter LLC · Fort Worth, TXBuilt 1986 · S/N S550-0108 N61CSLone Star Aviators LLC · Houston, TXBuilt 1981 · S/N 550-0349 N61HTCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 550-0157 N621KMEjair LLC · Conway, ARBuilt 1998 · S/N 550-0842 N622PGCapital Craft LLC · Wilmington, DEBuilt 1978 · S/N 550-0037 N623BGRrkj Aviation LLC · Cave Springs, ARBuilt 1986 · S/N S550-0105 N624PLLow Tide LLC · Riverside, IABuilt 1982 · S/N 550-0402 N627BCHard Eight Investments LLC · Alpharetta, GABuilt 1999 · S/N 5500868 N628GBMmx LLC · Chesapeake, VABuilt 2001 · S/N 550-0991 N62TLDialysis Clinic Inc · Nashville, TNBuilt 1983 · S/N 550-0462 N630SPAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1981 · S/N 550-0237 N631TSLettuce Fly LLC · King City, CABuilt 1990 · S/N 5500631 N633ATNrx Pharmaceuticals Inc · Wilmington, DEBuilt 1985 · S/N S550-0066 N633PCDjd Aero LLC · Lubbock, TXBuilt 2004 · S/N 550-1085 N637ATN637at LLC · Punta Gorda, FLBuilt 1979 · S/N 5500371 N63JTLiberty Flight Co LLC · Jonesboro, ARBuilt 1988 · S/N S550-0156 N63RAEncore Aviation LLC · Indian Trail, NCBuilt 2006 · S/N 550-1125 N63RSTeewinot Aviation LLC · Jackson, WYBuilt 1985 · S/N S550-0046 N63TKBeaver N63tk LLC · Salem, ORBuilt 1997 · S/N 550-0803 N640YBluebonnet Aviation Club LLC · San Marcos, TXBuilt 1988 · S/N 550-0590 N64RT64rt LLC · Birmingham, ALBuilt 1998 · S/N 550-0840 N64TFParatus Jets LLC · Auburn, INS/N 550-0064 N655MMBem Flight Deck LLC · Wilmington, DEBuilt 1993 · S/N 5500720 N656PSCalifornia Oregon Broadcasting Inc · Medford, ORBuilt 1978 · S/N 550-0009 N65DVLone Star Ag · Texico, NMBuilt 1989 · S/N 550-0624 N65FFN65ff LLC · Liverpool, NYBuilt 1988 · S/N 550-0585 N662CBGold Dust Potato Processors Inc · Malin, ORBuilt 2003 · S/N 550-1062 N666DSDaviator LLC · Homer, AKBuilt 1985 · S/N S550-0056 N668AJMt Equipment LLC · Sarasota, FLBuilt 1982 · S/N 550-0442 N668CBVolunteer Corp · Clarksville, TNS/N 550-1068 N66MCDodson International Parts Inc · Rantoul, KSS/N 550-0239 N66MQBravo Partners LLC · Wilmington, DEBuilt 2000 · S/N 550-0913 N66PFWorldwide Option LLC · Lewes, DEBuilt 1998 · S/N 550-0860 N674GSale Reported · Marana, AZSale reportedS/N 550-0435 N674NDDodson International Parts Inc · Rantoul, KSS/N 550-0852 N675SSStructural Steel Services Inc · Meridian, MSBuilt 2006 · S/N 550-1123 N676CMMike Mike LLC · Wilmington, DEBuilt 1980 · S/N 550-0186 N676RAJet Air Inc · Iowa City, IABuilt 1999 · S/N 550-0876 N678GSMeisner Aircraft Inc · Burlington, WIBuilt 1992 · S/N 5500710 N67BEPonderosa Aviation LLC · Safford, AZBuilt 1989 · S/N 550-0619 N67BKSdkt Properties LLC · Salinas, CABuilt 2002 · S/N 550-0997

Back to AD 90-07-10 R1