Skip to content

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.

N736CJAndrews Brian S · Venus, TXBuilt 1977 · S/N R1722418 N736CKOk Tire Factory Inc · Okanogan, WABuilt 1977 · S/N R1722419 N736CNThomas Jamie A · Summersville, WVBuilt 1977 · S/N R1722422 N736CQHicks Shannon M · Lake Havasu City, AZBuilt 1977 · S/N R1722424 N736CSMenard Denis J · Louisville, KYBuilt 1977 · S/N R1722426 N736DEJasinski Anthony S · Bluemont, VABuilt 1977 · S/N R1722438 N736DHAviation Management LLC · Missoula, MTBuilt 1977 · S/N R1722441 N736DJFly Guy LLC · Murphy, TXBuilt 1977 · S/N R1722442 N736DKNelson Thomas H Jr · Chatham, MSBuilt 1977 · S/N R1722443 N736DMCasillas Carlos Eduardo · El Paso, TXBuilt 1977 · S/N R1722445 N736DNCousin William C · Hugo, OKBuilt 1977 · S/N R1722446 N736DUJm Bryson Inc · Granada Hills, CABuilt 1977 · S/N R1722452 N736DVBradford William O Jr · Huntersville, NCBuilt 1977 · S/N R1722453 N736EBTesta Sam C · Bonners Ferry, IDBuilt 1977 · S/N R1722459 N736ECBailey Mark H · Bluffton, SCBuilt 1977 · S/N R1722460 N736EDSelwyn Rebekah L Trustee · Eastsound, WABuilt 1977 · S/N R1722461 N736EFWalding Grant L · Coos Bay, ORBuilt 1977 · S/N R1722499 N736EGMoore Samuel R Jr · Tabernacle, NJBuilt 1977 · S/N R1722464 N736EHGarvin Lee E · Brookings, ORS/N R1722465 N736EJDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N R1722466 N736EMPerez Carlos E · Bayshore, NYBuilt 1977 · S/N R1722469 N736EQHarper Henry A · Mesquite, NVBuilt 1977 · S/N R1722472 N736ESRainbow Aviation Services · Kingsville, MOBuilt 1977 · S/N R1722474 N736ETSchuler Darrell II · Bridgeport, NEBuilt 1977 · S/N R1722475 N736EUSolano Aircraft Maintenance LLC · Torrance, CAS/N R1722476 N736EVRogerson James H · Chandler, AZBuilt 1977 · S/N R1722477 N736EXHolt Aviation LLC · Clear Lake, IABuilt 1977 · S/N R1722479 N736FADebold Denise S · Spring, TXS/N R1722482 N736FBNimbus 2000 LLC · Farmington, UTS/N R1722483 N736FCJrm Wings LLC · Farmington, UTBuilt 1977 · S/N R1722484 N736FDKing Brad C · Langley, WABuilt 1977 · S/N R1722485 N736FFNorkunas Lisa M · Fontana, CABuilt 1977 · S/N R1722487 N736FGJ M Carrigan LLC · Sanibel, FLBuilt 1977 · S/N R1722488 N736FJHartwick Kevin D · Crescent City, CABuilt 1977 · S/N R1722490 N736FNWilliamson Thomas M · Southport, NCBuilt 1977 · S/N R1722493 N736FSRussell Larry B DBA · Union City, TNBuilt 1977 · S/N R1722497 N736FTChoice Aviator LLC · Chandler, AZBuilt 1977 · S/N R1722498 N736FVDel Rio Advisors LLC · Modesto, CABuilt 1977 · S/N R1722500 N736FXKelcy Wyman O · Early, TXBuilt 1977 · S/N R1722502 N736FYPhydeaux Aviation Ltd · Spartanburg, SCBuilt 1977 · S/N R1722503 N736GAPlane Jane Aviation LLC · Sylvania, GABuilt 1977 · S/N R1722505 N736GBSilva Monico · Albuquerque, NMBuilt 1977 · S/N R1722506 N736GCSilvers Morris · Burnsville, NCS/N R1722507 N736GDPactolus Investments LLC · Blounts Creek, NCS/N R1722508 N736GGLedocq Melissa A · Green Bay, WIBuilt 1977 · S/N R1722511 N736GHTriple R Flying · Monticello, IABuilt 1977 · S/N R1722512 N736GJRyan Transfer Inc · Tilden, NEBuilt 1977 · S/N R1722513 N736GKOrten Steven S Md · Dallas, TXBuilt 1977 · S/N R1722514 N736GNMorrison Scott W · Kokomo, INS/N R1722517 N736GUFaria Farms Inc · Tipton, CABuilt 1977 · S/N R1722523

Back to AD 81-13-10 R1