Registered aircraft · 5,102

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:81-12-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:81-12-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:81-12-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:81-12-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:81-12-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:81-12-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.

N130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N T20608130 N130XRM&A Adams Family Lp · Mckinney, TXS/N 32R-7887003 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

Back to AD 81-12-06 R1