Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N22136Zest Fest Corporation Of Oregon · San Diego, CAS/N 32R-7887247 N2213NTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 27-0284 N221ACAusten Air LLC · Lees Summit, MOBuilt 1980 · S/N 31-8152045 N221CATripp Charles A Jr · Brownsville, TNBuilt 1977 · S/N 61P-0392-133 N221CSTriple Seven Aviation LLC · Newark, DEBuilt 1977 · S/N 32R-7780424 N221GHWitham Aviation LLC · Stuart, FLBuilt 1976 · S/N 32R-7680502 N221GSBarientos Bryan I · Petaluma, CABuilt 2001 · S/N T18208034 N221WGLove Kenneth J · CombaningnswBuilt 1976 · S/N 32R-7680478 N2220EBerry Islands LLC · Holly Hill, FLBuilt 1979 · S/N 32R-7987063 N2220JTrj Aero Holdings LLC · Tequesta, FLBuilt 1978 · S/N 32-7940008 N22213Stemmer Kenneth Edward · Palm Desert, CABuilt 1978 · S/N 32R-7887248 N2221GWs Management Of Tyler LLC · Shreveport, LABuilt 2000 · S/N 27-0291 N22262Oldenkamp David J · Payson, AZBuilt 1978 · S/N 32-7840191 N2228THulsey Hunter · Madison, MSBuilt 2005 · S/N T18208480 N22293Jacobson Duane A · Marco Island, FLBuilt 1978 · S/N 32R-7887253 N22295Poole Frederick J · Meridian, MSBuilt 1978 · S/N 32R-7887254 N222FGoddspeed LLC · Encinitas, CABuilt 2000 · S/N T20608154 N222HMAmerican Saddlair LLC · Park City, UTBuilt 1994 · S/N 27-0183 N222JLThomas Kent C · Muncie, INBuilt 1973 · S/N 32-7340135 N222KHPavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305097 N222LEHigh View Air LLC · Driftwood, TXBuilt 1965 · S/N 1525-187 N222MMYount Patrick G · Buckeye, AZBuilt 1991 · S/N 27-0086 N222PPPreferred Landing LLC · Tomball, TXBuilt 1978 · S/N 32R-7985013 N222SNNorris Jason M · Smyrna, TNBuilt 1969 · S/N 31004 N222WBPower Robert R · Brenham, TXBuilt 1968 · S/N 27-3992 N222WPFord Scott S · Punta Gorda, FLBuilt 1974 · S/N E-516 N222ZMPresentation Impact LLC · Sandia Park, NMBuilt 1990 · S/N 4622115 N22316Mcleland David L · Sellersburg, INBuilt 1999 · S/N 27-0276 N2231XCaselato Andre Luiz Puls · Kissimmee, FLBuilt 2000 · S/N 27-0296 N22320B Lillico Petroleum Consultants Ltd · Eastport, IDBuilt 2000 · S/N 27-0297 N2232ZAlaverdi Omeed · California, MDBuilt 1976 · S/N 76-31135 N2234UMountain States Casing Co LLC · Timnath, COBuilt 2006 · S/N T18208485 N22363Barnes Welding Inc · Waterville, WABuilt 1978 · S/N 32R-7887258 N22370Top Flight Sales Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887259 N2237AKimber 123 Holdings LLC · Morgantown, WVBuilt 1978 · S/N 32R-7987016 N2237SOregon State Police · Salem, ORBuilt 2006 · S/N T18208488 N223DAAerodrome LLC · Louisville, KYBuilt 1970 · S/N 27-4563 N223MDPremier Engineering Inc · San Antonio, FLBuilt 1974 · S/N 32-7440154 N223MSNy Dc LLC · Washington, DCBuilt 2005 · S/N 27-0340 N2241BHanneman Michael W · Abilene, TXBuilt 1978 · S/N 32R-7985018 N2243FDavenport Mark B · Placentia, CABuilt 1978 · S/N 32R-7987071 N22446Ag Care Inc · Apopka, FLS/N 32R-7887260 N2244QField George Jr · Overton, NVBuilt 1979 · S/N 32R-7987107 N22450Red Mountain Express Care LLC · Queen Creek, AZBuilt 1978 · S/N 32R-7887261 N2245ANo Limits Aviation Group LLC · Louisville, KYBuilt 1978 · S/N 32R-7887285 N2247ABcs Aviation LLC · Colquitt, GABuilt 1978 · S/N 32R-7887286 N224JJCox Gerald Lee · Shepherdsville, KYBuilt 1994 · S/N 4622155 N2252ZBerman Rayanne S · Hatfield, PABuilt 2006 · S/N T18208490 N225HMSmithart Eric W · San Juan, PRBuilt 1963 · S/N 27-2341 N225KTAnselmetti Federico · Miami, FLBuilt 1993 · S/N 27-0165

Back to AD 91-21-01 R1