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.

N780CFAlcyone Trust Corporation Trustee · Wichita, KSBuilt 1978 · S/N 550-0014 N782STBlue Skies Aviation Of Daytona Inc · Ormond Beach, FLBuilt 1991 · S/N 550-0679 N785CWConstruction Solutions & Consulting LLC · Sedalia, MOBuilt 2000 · S/N 550-0916 N789JKJk Aircraft Options LLC · Aripeka, FLBuilt 1980 · S/N 5500116 N78MDValiar Ltd Co Trustee · Casper, WYBuilt 2001 · S/N 550-0970 N790ALAngels Envy Aviation LLC · Denison, TXBuilt 1985 · S/N S550-0024 N795JKN90tr LLC · Paso Robles, CABuilt 1978 · S/N 550-0027 N796MACypress Aircraft Sales LLC · Clermont, FLBuilt 2000 · S/N 550-0941 N797TEN797te LLC · Hermiston, ORBuilt 2001 · S/N 550-0962 N79DAPahlisch Homes Inc · Bend, ORBuilt 1999 · S/N 550-0875 N7HJHessjet LLC · Mc Donald, TNBuilt 2001 · S/N 550-0983 N7YAVander Dussen Robert · Clovis, NMBuilt 1999 · S/N 550-0880 N800MTTarp-It Air LLC · Ellensburg, WABuilt 2001 · S/N 550-0981 N800WTBode Aviation Inc · Albuquerque, NMBuilt 1998 · S/N 5500859 N802CAThree Thirty Three LLC · Collierville, TNBuilt 2002 · S/N 550-1034 N802QTuskegee Leasing LLC · Sioux Falls, SDBuilt 1988 · S/N S550-0157 N805LCW Brown Enterprises Inc · Durant, OKBuilt 1988 · S/N 550-0581 N807MBJ&P Aviation LLC · Jasper, ALS/N 550-0694 N80PTCb80pt LLC · Stuart, FLBuilt 1998 · S/N 550-0839 N811JANature Coast Aviation LLC · Homosassa, FLBuilt 2000 · S/N 550-0952 N811VGTwo Oceans 555 LLC · Fort Myers, FLBuilt 1979 · S/N 5510017 N812HACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1985 · S/N S550-0054 N812MEBig Blue Sky Aviation Co · Midland, TXBuilt 2002 · S/N 550-1023 N813JDApple Air LLC · Tieton, WABuilt 1998 · S/N 550-0838 N818RJCamacho Xpress LLC · Miami, FLBuilt 1985 · S/N S550-0083 N819EKMaisaka LLC · Fremont, CABuilt 1984 · S/N S550-0009 N819KRPrestige Worldwide Flights LLC · Imperial, CABuilt 1979 · S/N 550-0114 N819SCHb4 LLC · Las Vegas, NVBuilt 1997 · S/N 550-0818 N820MCMontana 8083 Leasing Co LLC · Kalispell, MTS/N 550-0106 N823PMHernco Gp LLC · Fort Worth, TXBuilt 2003 · S/N 550-1064 N826RTHunter Resources LLC · Bossier City, LABuilt 1981 · S/N 551-0056 N828BGSweet Seasons Aviation LLC · Pharr, TXBuilt 1992 · S/N 550-0716 N829CBN829cb LLC · Amarillo, TXBuilt 1998 · S/N 550-0829 N829TGLulays Aviation LLC · Salem, ORS/N S5500010 N829TWTwhiskey Aviation LLC · Lawton, OKBuilt 1991 · S/N 550-0682 N82MLJltbm Investments Inc · Park City, UTBuilt 1982 · S/N 550-0408 N82VMAfo Holdings LLC · Sheridan, WYBuilt 1985 · S/N S550-0051 N830ECAvfrac Nb LLC · Seguin, TXBuilt 1987 · S/N S550-0139 N833JPEpic Aviation Inc · New Smyrna Beach, FLS/N 550-0315 N8344MAerotrust Services Corp Trustee · Wilmington, DEBuilt 1988 · S/N 550-0577 N834DCYoung John A Trustee · Driggs, IDBuilt 1985 · S/N S5500035 N843MLGlobal It Air LLC · Suwanee, GAS/N 550-0953 N84LGLanding Gear 7 LLC · Bossier City, LABuilt 1984 · S/N S550-0013 N851HSCp Expansion 2 LLC · Little Rock, ARBuilt 2002 · S/N 550-1028 N852HAAirspeed Aviation LLC · Millersburg, OHBuilt 1980 · S/N 550-0382 N854JAN854ja LLC · Walterboro, SCBuilt 2000 · S/N 550-0920 N858RMPnd Enterprises LLC · Sarasota, FLBuilt 2000 · S/N 550-0914 N85HEMongoss Inc · Livingston, LABuilt 1980 · S/N 550-0162 N862KN862k LLC · Houston, TXBuilt 1981 · S/N 550-0257 N864HABravo Preferred Partners LLC · Solon, OHBuilt 1999 · S/N 550-0864

Back to AD 90-07-10 R1