Registered aircraft · 4,001

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-13-10-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-13-10-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-13-10-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-13-10-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-13-10-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-13-10-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.

N875RHGreat Lakes Aviation LLC N875rh · Antioch, ILBuilt 1978 · S/N R1722964 N87767Usda Forest Service Fepp · Malvern, ARBuilt 1967 · S/N R1720105 N8781CNationwide Aviation LLC · Hudson Oaks, TXS/N 34-7670154 N878SSMcdaniel Mark · Martinsville, INBuilt 1978 · S/N 34-7870413 N87CCWalton Marketing Inc · Fort Worth, TXBuilt 1981 · S/N 34-8133148 N87JTN87jt Inc · Lewes, DEBuilt 1977 · S/N 34-7770274 N87LEAircraft Partner Holdings Inc Trustee · BerlinBuilt 2002 · S/N 1190 N87LTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1996 · S/N 3447013 N87UPAir Transport Service LLC · Wilmington, DEBuilt 1999 · S/N 34-49144 N8814CGharazeddine Raja N · Kaplan, LABuilt 1976 · S/N 34-7670155 N8822ZSmith Roy · Houston, TXBuilt 1980 · S/N 34-8170018 N8841TReid Cynda R · Trout, LABuilt 2008 · S/N 81394 N885CVOregon Air Partnership · Encino, CAS/N P337-0050 N885DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 250479 N88779Drexler Daniel L · Harrison, TNS/N R1720132 N887JBBertrand Carolyn L · Ridgecrest, CABuilt 1966 · S/N 337-0559 N88817Penner Gordon Kenneth · Lebanon, OHBuilt 2011 · S/N 73244 N888BAmerican Airpower Museum · Farmingdale, NYBuilt 1967 · S/N 3370586 N888BCTwo Hundred Co · OntarioNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 25-0460 N888BGOgden Thomas C · New Cumberland, WVBuilt 1973 · S/N 33701508 N888EWWilmes Window Mfg Co Inc · Santa Claus, INS/N 34-8170027 N888HWEvidence Vault Company Inc · Orchard Park, NYBuilt 1981 · S/N 25-0590 N888LCoats Robert Steven · Apex, NCS/N 007 N888RSAero Adair LLC · Valparaiso, INBuilt 1978 · S/N 28R-7803347 N888TCSilva Daniel J · Grass Valley, CABuilt 1977 · S/N 28R-7703103 N8896VWheels Down 2 LLC · Bozeman, MTBuilt 1977 · S/N R1722322 N8899WQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 28R-7803046 N889LDSkydance Aviation LLC · Norfolk, VABuilt 2004 · S/N 1434 N88FGGetgood G Fraser · Fredericksburg, VABuilt 2004 · S/N 1918 N88JSDoubravsky Mark Edward · Goldendale, WAS/N 6082C N88RLLarson Kris K · Fullerton, CABuilt 1977 · S/N 28R-7703240 N88TNErwa Mohamed · Lago Vista, TXBuilt 1979 · S/N P3370341 N88VFMillennial Aviation LLC · Chatsworth, CAS/N 34-8233171 N88WYEastern Nevada Aviation LLC · Gardnerville, NVBuilt 2007 · S/N GC-001 N8907FHughes Michael Anthony · Meridian, IDBuilt 1977 · S/N 28R-7703007 N8907VSmith Melvin Roy · Gulf Breeze, FLBuilt 1977 · S/N R1722323 N891SGSouthern Aircraft LLC · Valdosta, GABuilt 1975 · S/N 34-7570311 N8923VMollica Richard Anthony · Oxnard, CABuilt 1977 · S/N R1722326 N8925TSuslavich Frank · Ennis, MTBuilt 1984 · S/N 348433007 N8931Kohler Christopher S · Bellville, OHBuilt 1970 · S/N 459 N8939VBray Bradley DBA · North Charleston, SCBuilt 1977 · S/N R1722328 N8955C4k Endeavors LLC · Wadsworth, OHBuilt 1976 · S/N 34-7670158 N8989MSkymaster Mods & Parts LLC · Castalian Springs, TNS/N P3370101 N898HCSmith Andy · Fitzgerald, GABuilt 1977 · S/N R1722628 N899AFApplication Dynamics LLC · Cape Coral, FLBuilt 1967 · S/N M337-0188 N899DWValiair Lc Trustee · Casper, WYBuilt 1984 · S/N 28R-8431011 N899SPPolyspray Corp · Asheboro, NCBuilt 1967 · S/N R172-0101 N89CDRodz Lawn Care LLC · Mcallen, TXBuilt 2005 · S/N 1520 N89HUGbh Aviation · Santa Monica, CABuilt 2009 · S/N 3077 N89KRholetter Wayne C · Westminster, SCBuilt 1946 · S/N 246

Back to AD 81-13-10 R1