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.

N736GVChristiansen Drilling Inc · Ely, NVBuilt 1977 · S/N R1722524 N736GWMartin Stephen E · Pampa, TXBuilt 1977 · S/N R1722525 N736GZJust US Air LLC · Bradenton, FLBuilt 1977 · S/N R1722528 N736HATurner Daniel A · Paragould, ARBuilt 1977 · S/N R1722529 N736HBZero-To-1500 LLC · Tacoma, WABuilt 1977 · S/N R1722530 N736HDGuthrie John Alex · San Ramon, CABuilt 1977 · S/N R1722532 N736HGMcclure Richard A · Victoria, TXBuilt 1977 · S/N R1722535 N736HMAir Force Academy Aero Club · Usaf Academy, COBuilt 1977 · S/N R1722540 N736HNRegistration Pending · Orange Grove, TXRegistration pendingBuilt 1977 · S/N R1722541 N736HSHodgskiss Ben · Choteau, MTBuilt 1977 · S/N R1722545 N736HWInvestair LLC · Conway, ARBuilt 1977 · S/N R1722549 N736HZBird Chad W · Santa Ana, CABuilt 1977 · S/N R1722552 N736JESylvan Air Associates LLC · Lapeer, MIBuilt 1977 · S/N R1722557 N736JFHartsuyker David L · Jackson, CABuilt 1977 · S/N R1722558 N736JHLloyd Stephen C · Erie, COBuilt 1977 · S/N R1722560 N736JKMcfeaters Ryan C · Madisonville, TNBuilt 1977 · S/N R1722562 N736JQRaven Limited · Seattle, WABuilt 1977 · S/N R1722567 N736JRMckibben Claude · Rochelle, ILBuilt 1977 · S/N R1722568 N736JTRose Chris W · Rochester, NYS/N R1722570 N736JVRegistered aircraftBuilt 1977 · S/N R1722572 N736JWHutcherson David R · Gretna, VABuilt 1977 · S/N R1722573 N736JYBorreson Anthony · Mariposa, CABuilt 1977 · S/N R1722575 N736KCGreen Robert W · Santa Barbara, CABuilt 1977 · S/N R1722579 N736KDAmts LLC · Pleasanton, CABuilt 1977 · S/N R1722580 N736KERegistration Pending · Cozad, NERegistration pendingBuilt 1977 · S/N R1722581 N736KFEason Richard O · Orono, MEBuilt 1977 · S/N R1722582 N736KNTurbine Financial Group LLC · Ogden, UTBuilt 1977 · S/N R1722589 N736KPSutton Aircraft Salvage LLC · Palmer, AKS/N R1722590 N736KSRigfuel LLC · Eureka, MTS/N R1722593 N736KYSicheneder Scott A · Wasilla, AKBuilt 1977 · S/N R1722599 N736LDSteinmeyer Peter A · Arvada, COBuilt 1977 · S/N R1722604 N736LGM & R Aviation LLC · Fairview, ORBuilt 1977 · S/N R1722607 N736LHDdjrrm Enterprises LLC · Plainfield, INBuilt 1977 · S/N R1722608 N736LLSmith Matthew R · Thomaston, GAS/N R1722611 N736LMRaducu Radu · Bismarck, NDBuilt 1977 · S/N R1722612 N736LPAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1977 · S/N R1722614 N736LVEggleston Kenneth W · Bethel, AKBuilt 1977 · S/N R1722620 N736LWDrr Boonville LLC · Boonville, NYBuilt 1977 · S/N R1722621 N736LXTaylor Tom M · Tulsa, OKBuilt 1977 · S/N R1722622 N736MC3 Pandas LLC · Farmington, NMBuilt 1977 · S/N R1722626 N736MDBrown Tyler Cooper Trustee · Anchorage, AKBuilt 1977 · S/N R1722627 N736MFTurnagain Airventures LLC · Anchorage, AKBuilt 1977 · S/N R1722629 N736MKDavis Rodger C · Anchorage, AKBuilt 1977 · S/N R1722633 N736MLH & L Acquisitions LLC · Flushing, MIBuilt 1977 · S/N R1722634 N736MNSeidler Matthew J · Anchorage, AKBuilt 1977 · S/N R1722635 N736MPDarby Air Ltd · Lincolnshire, ILBuilt 1977 · S/N R1722636 N736MTLowe John H · Tifton, GABuilt 1977 · S/N R1722640 N736MWWestern Radio Services Co · Prineville, ORBuilt 1977 · S/N R1722643 N736MYLandry Cheryl A · Mendon, MABuilt 1977 · S/N R1722645 N736NCGully Justin T · Anoka, MNS/N R1722649

Back to AD 81-13-10 R1