Skip to content

Registered aircraft · 68,369

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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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.

N210STWar Eagle Enterprises LLC · Missoula, MTBuilt 2001 · S/N SH2363 N210SVBevis Richard L · Middletown, OHBuilt 1978 · S/N 17271361 N210SXSims Stephen E · Locust Grove, GABuilt 1946 · S/N 394 N210WDShillieto Gordon W · Burlington Flats, NYBuilt 1965 · S/N 936 N210WECross Services LLC · Wilmington, DEBuilt 1994 · S/N 24-3352 N21104Ferraro Thomas P · Mckinney, TXBuilt 1938 · S/N 5830 N2110BHorinek David L · Goodland, KSBuilt 1970 · S/N P-463 N2110TN2110t LLC · Columbus, OHBuilt 1971 · S/N 28R-7135056 N21116Prestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7916025 N2111ETemple Craig A · Fort Lauderdale, FLBuilt 1966 · S/N 2 N2111FDhs Operations LLC · Wilmington, DEBuilt 1978 · S/N 44-7995153 N2111NLongacre John David · Anchorage, AKS/N 12347 N2111SSchwab Jollina Michelle · Arlington, TXBuilt 1970 · S/N 28R-31048 N2111ZNunn Henry · Noble, OKBuilt 1973 · S/N 28-7305515 N21123Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916027 N21124Mitchell Andrew D Trustee · Winnie, TXBuilt 1974 · S/N 17263894 N21126Aviation Academy LLC · Wichita, KSBuilt 1974 · S/N 17263895 N2112FBank Of Utah Trustee · Salt Lake City, UTS/N 44-7995154 N2112GA&J Aircraft Leasing Inc · Burlington, COBuilt 1978 · S/N 28-7816367 N2112KRocky Mountain Aircraft Services LLC · Broomfield, COBuilt 1978 · S/N 28-7990234 N2112NV & R Aviation LLC · Georgetown, TXBuilt 1979 · S/N 28-7990276 N2112PHardin John M · Terrell, TXBuilt 1956 · S/N 23-703 N2112QSoloman Michael Glenn · Dallas, GABuilt 1974 · S/N 177RG0512 N2112TMarsh James M · Polkton, NCBuilt 1971 · S/N 28R-7130002 N2112ZWilson Mickey Ray · Skagway, AKBuilt 1979 · S/N 28-7990394 N21131Emge Douglas W · Albertville, ALBuilt 1978 · S/N 28-7990035 N21135Shannon Air Museum LLC · Fredericksburg, VABuilt 1937 · S/N 5903 N2113ASale Reported · Glasgow, MTSale reportedS/N 18-1844 N2113JAlternate Air Inc · Seattle, WABuilt 1975 · S/N 17264982 N2113KCalvin B Wiley · Summer Shade, KYS/N TD-283 N2113T10 Mile Final 33 LLC · Charleston, SCBuilt 1971 · S/N 28R-7135058 N2113WMarschke Corey A · Stevens Point, WIBuilt 1973 · S/N M-1441 N2114CLegacy By Design LLC · Durham, CAS/N 2114 N2114FChapel Hill Flying Club DBA · Sanford, NCBuilt 1978 · S/N 28-7916169 N2114JMonaco Joseph · Castleton, VTBuilt 1978 · S/N 28-7916224 N2114KRcs Services LLC · California, MDBuilt 1978 · S/N 28-7990235 N2114PRiggin Flight Service Inc · Madison, SDS/N 23-705 N2114TPulka Michael R · Yardley, PABuilt 1971 · S/N 28R-7135060 N2114WHippensteel Michael J · Newville, PABuilt 1973 · S/N M1449 N2114XGsi Corp · Eastham, MABuilt 1970 · S/N 17259495 N21157Beta Fleet LLC · South Burlington, VTBuilt 1974 · S/N 17263901 N21159Kope Gregory A · Leesburg, VABuilt 1974 · S/N 17263902 N2115JMartin Aviation LLC · Bargersville, INBuilt 1978 · S/N 28-7916196 N2115MRedman Company LLC · Troy, MIBuilt 1972 · S/N 177-01703 N2115UDengler Steven G · Lopez Island, WAS/N 163 N21167Tidewater Aviation LLC · Easton, MDBuilt 1978 · S/N 28-7916028 N2116FVarani Hugo Leonardo Cordova · Houston, TXBuilt 1978 · S/N 28-7916171 N2116JWard John C · Novato, CABuilt 1978 · S/N 28-7916197 N2116TBeshai Charles John · Huntington Beach, CABuilt 1971 · S/N 28R-7135061 N2116UBreaux Family Investments LLC · Alexander City, ALS/N 28-7990329

Back to AD 90-04-06 R1