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.

N72ZGSale Reported · Hood River, ORSale reportedBuilt 2006 · S/N T20608700 N730MCCpc2 Aviation LLC · Hoover, ALBuilt 1965 · S/N 27-3097 N731WN64gs LLC · Van Nuys, CABuilt 1971 · S/N 24-4989 N7332VLorenz William D · Benson, MNBuilt 1969 · S/N 32-1 N7335TNever Repress Laughter LLC · Villa Rica, GABuilt 1977 · S/N R18200029 N733GPHorton Luther · Lakeland, FLBuilt 1962 · S/N 24-3213 N735QStuart Aviation Holdings LLC · Stuart, FLBuilt 1978 · S/N 31-7812089 N735RCSoto Flavio Cesar · Nogales, AZBuilt 1998 · S/N 4636167 N736XPsa LLC · Fort Myers, FLBuilt 1973 · S/N 32-7340095 N737EBVx Ventures LLC · Castle Rock, COBuilt 2002 · S/N T18208135 N738CFishgold Valerie Trustee · Scottsdale, AZBuilt 2005 · S/N 3255028 N7392VBrown Mill Ranch LLC · Lamar, COBuilt 1969 · S/N 32-13 N73CZBm Air LLC · Anaconda, MTBuilt 1980 · S/N 31-8052177 N73DNMurdoc Aviation LLC · Destin, FLBuilt 1973 · S/N 73-32-110 N73LKMoore David E · Stuart, FLBuilt 1979 · S/N 31-7912123 N73RTRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N 31-8252023 N73RWSeppala Joel H · Taylors, SCBuilt 1971 · S/N 32-7240039 N73WHBumble Bee Aviation LLC · Brookfield, WIS/N 27-7305184 N740HCVuksanovic David A · Fountain Hills, AZBuilt 1984 · S/N 31P-8414043 N7411SNaik Narayan · Claremore, OKBuilt 1969 · S/N 60-0016 N74199Aldrich Curtiss R · Aguila, AZBuilt 1965 · S/N 27-3026 N7419SKcantarano LLC · Mukilteo, WABuilt 1969 · S/N 61-0004 N7425SSweeney Sean M · Reunion, FLBuilt 1969 · S/N 61-0010 N7426LWright Air Service Inc · Fairbanks, AKBuilt 1972 · S/N 31-812 N742HMBennett Aviation LLC · New York, NYBuilt 2001 · S/N T20608304 N7432LStandard Air LLC · West Linn, ORBuilt 1972 · S/N 31-820 N7434LIsland Wings Inc · Fort Lauderdale, FLBuilt 1972 · S/N 31-822 N7438SFrana Joel A · Fort Myers, FLBuilt 1969 · S/N 60-0025 N7441SKp Stunt Productions Inc · Burlington, NDBuilt 1969 · S/N 61-0024 N744JCAck-Pg-LLC · Charlestown, MABuilt 1979 · S/N 31-7912119 N744RVAustin Aviation LLC · Maumelle, ARBuilt 2003 · S/N 4636342 N745AALarson Stephen Blair · Raleigh, NCBuilt 1968 · S/N 32-40449 N746AJNesta Joseph A · Kelleys Island, OHBuilt 1975 · S/N 32-7540082 N746RRSolis Inc LLC · Alton, NHBuilt 1974 · S/N 75-32-147 N747ATHaueisen Jessica · Franklin, GABuilt 1978 · S/N 27-7854080 N747CGAir Americus LLC · Johns Creek, GABuilt 1981 · S/N 31-8152070 N747HSale Reported · Santa Rosa, CASale reportedBuilt 1965 · S/N 1492-72 N747MEEvans Mark W · Camillus, NYBuilt 1993 · S/N 117 N7482WSkys Edge Aviation LLC · Midland, TXS/N 27-3524 N748NPBelle Island Management LLC · Fort Lauderdale, FLBuilt 1969 · S/N 31474 N74932Ruocco 220 LLC · Escondido, CABuilt 1973 · S/N 31-7305074 N7496SSmith Linda L · Port Charlotte, FLBuilt 1970 · S/N 60-0047-108 N74972H&H Aircraft LLC · Grey Eagle, MNBuilt 1973 · S/N 31-7305123 N74BBHy Aviation LLC · San Juan, PRBuilt 1971 · S/N 27-4750 N74DDN74dd Inc · Apalachicola, FLBuilt 1978 · S/N 31-7952016 N74LRRemy Lange · East Greenville, PAS/N 27-7405363 N74MJFord Richard M · Cartersville, GABuilt 1977 · S/N 31-7712065 N74PLAncient Pelican Aviation LLC · Vero Beach, FLS/N 27-7405272 N74WDNevada Viking Partners LLC · Stateline, NVBuilt 1973 · S/N 73-31065 N75014Hammonds Hangars Inc · Wilmington, DEBuilt 1976 · S/N 32R-7680246

Back to AD 81-12-06 R1