Skip to content

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N136RLRegistered aircraftBuilt 1978 · S/N E1326 N136SHLlano Capital LLC · Fredericksburg, TXBuilt 1994 · S/N E-2894 N136STScull Timber Co Inc · Tenaha, TXBuilt 1978 · S/N 18266476 N136TBColwell Paul · Scottsdale, AZBuilt 2001 · S/N E-3419 N136TCWeis Samuel K · Madera, CABuilt 1979 · S/N EA-15 N136TPSchacher Daniel E · Muleshoe, TXBuilt 1977 · S/N E-1176 N136TVReid Brian M · Boise, IDBuilt 1958 · S/N 51388 N136VPWartman Steven · Sandia Park, NMBuilt 1965 · S/N 28-21128 N136XNautical Skies LLC · Helena, MTS/N D-6215 N136YJanoski David M · Fort Worth, TXBuilt 1960 · S/N 24-1991 N137Bigfoot Aviation LLC · Saint Michael, MNBuilt 1960 · S/N 310-0028 N13701M-A-R-S Aircraft Leasing LLC · Williamsburg, VABuilt 1974 · S/N 17262953 N13703Kisser Carroll P · Alexandria, VABuilt 1974 · S/N 17262955 N1370ESprocket Aircraft Management LLC · Kennesaw, GABuilt 1978 · S/N 17270972 N1370QEvans Randall B Trustee · Fallon, NVBuilt 1977 · S/N 18503480 N1370SGolfbanks Leasing Partnership · Geneva, INBuilt 1976 · S/N 18264933 N1370UUnited States Air Force Aero Club · Usaf Academy, COBuilt 1976 · S/N 17267041 N13715Wingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17262962 N13719Precious Metal Aviation LLC · Menomonee Falls, WIBuilt 1974 · S/N 17262966 N1371DFrank Taylor Joseph · Tamarac, FLBuilt 1951 · S/N 19947 N1371FJones Michael Robert · Glen Rose, TXS/N 17254866 N1371GFall Gregory F · Hanson, MABuilt 1976 · S/N 310R0725 N1371TSaviortree House Ministries · Coarsegold, CABuilt 1972 · S/N 28-7225485 N1371UStanton Sport Aviation · Stanton, MNBuilt 1976 · S/N 17267042 N1371YFlightsuit Farmer LLC · Imperial, NEBuilt 1961 · S/N 17249071 N13721Muth Robert F · Whitefish, MTBuilt 1974 · S/N 17262968 N13723Johnson Darwin E Jr Trustee · Hollywood, ALBuilt 1974 · S/N 17262970 N13725Moster Paul C · Morristown, NJBuilt 1974 · S/N 17262972 N13727Ofarrell Scott A · Sterling Heights, MIBuilt 1974 · S/N 17262973 N1372ECsa Aircraft Leasing LLC · Park City, UTS/N 17270974 N1372UFerguson Joseph L II · Fairmont, WVBuilt 1976 · S/N 17267043 N1372VBoland Matthew S · Anchorage, AKS/N U20602588 N13731East Derrick A · Cullman, ALBuilt 1974 · S/N 17262977 N13732Bay Lux Ventures LLC · Tampa, FLBuilt 1974 · S/N 17262978 N13737Crosswinds Flight Center Inc · Drums, PABuilt 1974 · S/N 17262983 N13739Maroldy Robert S · Gahanna, OHBuilt 1974 · S/N 17262985 N1373EEagle Aviation LLC · Spearfish, SDBuilt 1978 · S/N 17270975 N1373FBaczewski Gary L · San Antonio, TXBuilt 1975 · S/N 18502837 N1373UWestberg Larry A · Milton, WIBuilt 1976 · S/N 17267044 N1373WGarces Manuel E · Jefferson, GABuilt 1963 · S/N 2654 N1373ZHoitt Edward D Jr · Deerfield, NHBuilt 1961 · S/N TD-479 N13741Rasmussen Tyler R · Independence, IAS/N 17262987 N13748Ries Farms LLC · Hastings, MNS/N 17262989 N1374EKjeldgaard James K · Fremont, NEBuilt 1978 · S/N 17270976 N1374FHegge Luke T · Pine City, MNBuilt 1966 · S/N 17254869 N1374SRenninger Log Homes · Meeker, COS/N 18264936 N1374USkydance Aviation LLC · Norfolk, VABuilt 1976 · S/N 17267045 N1374WWade Deborah D · Mineral Wells, TXBuilt 1963 · S/N 2655 N1374YBowden Richard P · Lenexa, KSBuilt 1961 · S/N 17249074 N13751Stegmaier Ann C · Eagan, MNBuilt 1974 · S/N 17262992

Back to AD 98-21-21 R1