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.

N1315BN1315b Aviation LLC · Wilmington, DEBuilt 2002 · S/N T18208147 N131FAJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 27-4097 N131PJCrosswinds Flight Center Inc · Drums, PAS/N 31-7912030 N131RLLeads Air Inc · Dover, DEBuilt 1989 · S/N 4622048 N131TVO'Brien Daniel H · Half Moon Bay, CABuilt 1977 · S/N 27-7754070 N1327TCedel Solutions LLC · Austin, TXBuilt 1972 · S/N 32-7240113 N1328NFirst Agri Inc · Sudan, TXBuilt 2005 · S/N T18208403 N132CHSimon Aviation LLC · Bourg, LABuilt 1978 · S/N 32R-7887060 N132DRAasap Construction Co Inc · Conway, SCBuilt 1980 · S/N 32R-8029108 N133DR814ma Inc · Van Alstyne, TXBuilt 2005 · S/N 3255027 N133KBIsland Time Aviation LLC · Peachtree City, GABuilt 1996 · S/N 4636049 N133PRJamian Corporation · Lewes, DEBuilt 1993 · S/N 27-0157 N133WCRegistration Pending · Huntingdon, TNRegistration pendingBuilt 2000 · S/N 4636251 N1343TWestern Cherokee Six LLC · Fort Collins, COBuilt 1972 · S/N 32-7240114 N134CHTeke Elevate LLC · San Antonio, TXBuilt 1978 · S/N 32R-7887138 N134GWFord Matthew L · Clayton, GABuilt 2002 · S/N T18208134 N134JFFlamingo Ridge Aviation LLC · Interlachen, FLBuilt 1993 · S/N 27-0150 N134TSDobalian Vaughn E · Jacksonville Beach, FLBuilt 1973 · S/N 61-0134-072 N1355TRmf Trucking LLC · Tuscaloosa, ALBuilt 1972 · S/N 32-7240115 N135GVreeland Equipment Rental LLC · Dayton, OHBuilt 1999 · S/N T20608077 N135RJKontz Gary Lee · Canby, MNBuilt 1967 · S/N 31-52 N135TSN135ts LLC · Lima, OHBuilt 2003 · S/N T20608413 N135TWValiair Lc Trustee · Casper, WYS/N 31-7852001 N13760Chiniewicz Michael · The Colony, TXBuilt 1969 · S/N 27-4409 N137JHFlatspin LLC · Belle Chasse, LABuilt 1981 · S/N 31-8252025 N137TSArk Aviation LLC · Moncks Corner, SCBuilt 2003 · S/N T20608415 N13803Crociati Douglas R · Plymouth, MABuilt 1969 · S/N 27-4448 N13817Conroy Philip L DBA · Colleyville, TXBuilt 1969 · S/N 27-4462 N13832Davey Spencer J · Spokane, WAS/N 27-4474 N13839Tyler Petroleum Inc · Tyler, TXBuilt 1970 · S/N 27-4480 N13862Reliance Island Inc · Wilmington, DEBuilt 1970 · S/N 27-4500 N13865Enzed Aviation Services LLC · Anchorage, AKS/N 27-4503 N13882Gc Aviation Services-1 LLC · Miamisburg, OHBuilt 1970 · S/N 27-4517 N1389BColumbia Safety Medical LLC · Kennewick, WABuilt 2005 · S/N T18208455 N138AZTablemax Aeronautics LLC · El Paso, TXBuilt 2004 · S/N T18208355 N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935 N13901Masscotte Michael · Mansfield, MABuilt 1970 · S/N 27-4533 N1391TAbita Air LLC · Covington, LABuilt 1972 · S/N 32-7240117 N13950Bml Aviation LLC · Arvada, COBuilt 1970 · S/N 27-4567 N13980Aileron Buzz LLC · Daytona Beach, FLBuilt 1970 · S/N 27-4598 N13982Bray Aviation LLC · Calera, OKBuilt 1970 · S/N 27-4600 N13984Smith Aircraft Holdings Inc · Wilmington, DEBuilt 1970 · S/N 27-4602 N13987Island Birds Inc · St Thomas, VIBuilt 1971 · S/N 27-4605 N13998Granger Vic · Union Grove, ALS/N 27-4616 N139CASquires Gregory K · Cedar Park, TXBuilt 1966 · S/N 24-4570 N139WTCotton Business Enterprises LLC · Hummelstown, PABuilt 2000 · S/N 27-0283 N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009 N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411 N13CEWilley R Scott · Layton, UTBuilt 1970 · S/N 31007 N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046

Back to AD 91-21-01 R1