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.

N21585Ck Leasing Services LLC · Wilmington, DES/N 17263978 N21588Jackson Hole Airport Board · Jackson, WYBuilt 1974 · S/N 17263979 N2158AHowlett Corey W · Wasilla, AKBuilt 1953 · S/N 18-1873 N2158THi Tech Helicopters Inc · Pocono Lake, PABuilt 2008 · S/N S1913 N2158ZTribute Aero LLC · Rochester, MIBuilt 1979 · S/N 28-7990403 N2159HBeverly Flight Center LLC · Middleton, MABuilt 1978 · S/N 28-7916192 N2159QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1979 · S/N 28-7916282 N215AFArmed Forces Aero Club · San Diego, CABuilt 1978 · S/N 17270844 N215BCMetzler Alan J · Reedsville, PABuilt 2005 · S/N 468-2005 N215BWLumkes John H · Lafayette, INBuilt 2007 · S/N 54 N215CDValiair Lc Trustee · Casper, WYBuilt 2001 · S/N 1114 N215CFHarter Ryan · Greenfield, INBuilt 2000 · S/N 24722 N215CRMidway Enterprises Inc · Wilmington, DEBuilt 1974 · S/N 0216 N215ERAmerican Capacitor Corp · Irwindale, CABuilt 1992 · S/N 10117 N215FRJjg Aviation LLC · Miami, FLBuilt 1978 · S/N 17271822 N215GRDesilva David I · Carolina, PRBuilt 2000 · S/N RV8-80573 N215JCCavanaugh Air LLC · Addison, TXBuilt 1984 · S/N 21546 N215KYSparrow Aviation LLC · Marietta, GABuilt 2004 · S/N 20-1045 N215LFLf Aviation Inc · Dover, DEBuilt 2004 · S/N 20-1032 N215MSMulcaire Jess E · Camp Verde, AZBuilt 1988 · S/N S1313 N215ROsmundson John C · Tumwater, WABuilt 1963 · S/N RO-1 N215RCGulf Coast Aviation LLC · New Orleans, LAS/N MA-89 N215RVJet & Rotor Aviation LLC · Sacramento, CABuilt 1973 · S/N 67-73 N215SMMyers Roy D · Naples, FLBuilt 2005 · S/N 81395 N215TWFreeze Timothy W · Waynesboro, VABuilt 2001 · S/N 198 N215UParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020136 N215WKaelberer Clyde · Montrose, MNBuilt 2017 · S/N 73013 N215ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881607 N21605Chandler Air Service Inc · Chandler, AZBuilt 1978 · S/N 28-7990054 N2160THughes Johnny D · Meridian, MSS/N 28-7205010 N2160ZDodger Aircraft LLC · Lewes, DES/N 210 N2161EBryn Terry P · Dazey, NDBuilt 1978 · S/N 17271172 N2161QSalty Dawg Aircraft Inc · Gasport, NYBuilt 1974 · S/N 177RG0561 N2161WMatz Michael D · Hanna, INBuilt 1974 · S/N M-1551 N2162Brammer Randall D · Belleville, ILBuilt 1973 · S/N P546 N2162KApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995198 N2162PLark Aircraft Leasing · Port Townsend, WABuilt 1956 · S/N 23-764 N2162REndthoff Wayne K · Beloit, WIBuilt 1969 · S/N 28-5474 N2162TVolantis LLC · West Fargo, NDBuilt 1971 · S/N 28-7205012 N2163ASharp Roscoe A · Deer Park, WAS/N 20-891 N2163FSkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 44-7995167 N2163GWilson Willard III · Cannon Falls, MNBuilt 1978 · S/N 28-7990194 N2163PCarroll Bodo W · Franklin, OHBuilt 1956 · S/N 23-765 N2163WBetancourt Jorge · Bowling Green, OHBuilt 1974 · S/N M-1550 N21643A&E Flying Club Of Los Angeles · Hawthorne, CABuilt 1974 · S/N 17263982 N21648Fox Victor Aviation LLC · Newnan, GAS/N 17263983 N2164AStejskal Frank P · Carmel, INBuilt 1952 · S/N 22-583 N2164GAulton New Energy Inc · Monterey, CABuilt 1978 · S/N 28-7990195 N2164WRegistration Pending · Carson City, NVRegistration pending, pending cancellationBuilt 1974 · S/N MB-682 N21659Ramin Jeanette J · Houston, TXBuilt 1938 · S/N 2552

Back to AD 90-04-06 R1