Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N3710DHiller Paul D · Grafton, OHBuilt 1957 · S/N 34410 N3710FDavis Charles Arthur Wesley · Petersburg, AKS/N 17255205 N3710LRegistered aircraftS/N 17253879 N3710UFollette Aviation LLC · Scottsdale, AZBuilt 1963 · S/N 18255110 N3711FMission Aviation Training Academy · Arlington, WABuilt 1966 · S/N 17255206 N3711SWittco Aero LLC · Vancouver, WAS/N 15062988 N3712LNoble Todd D · Hudson, INBuilt 1965 · S/N 17253881 N3712UVarian Dennis D · West Lafayette, OHBuilt 1963 · S/N 18255112 N3712VImperium Solutions LLC · Cheyenne, WYBuilt 1977 · S/N R1722261 N3712YRpx Technologies Inc · Stillwater, OKBuilt 1963 · S/N 21058212 N3713DHedgecock David H · Elkhorn, WIFirst renewal noticeBuilt 1957 · S/N 34413 N3713FDavis Jeffery S · Oregon City, ORBuilt 1966 · S/N 17255208 N3713RTroglio Joseph A · Peoria, ILBuilt 1966 · S/N 17255513 N3713UDaggy Curt L III · Red Bluff, CABuilt 1963 · S/N 18255113 N3714DZombo Brian T · Youngsville, NYBuilt 1957 · S/N 34414 N3714FSwearengen Sally · Tunica, MSBuilt 1966 · S/N 17255209 N3714LArizona Aircraft Leasing LLC · Mesa, AZBuilt 1965 · S/N 17253883 N3714USchaffer John Paul · Prior Lake, MNBuilt 1963 · S/N 18255114 N3714YReichelt Mark C · Big Sandy, MTBuilt 1963 · S/N 21058214 N3715JSmoot Nathan · Fairbanks, AKS/N 18255115 N3715RFriederich Claudio T · Honolulu, HIBuilt 1966 · S/N 17255515 N3715SBruton Alexander C · Swansboro, NCBuilt 1963 · S/N 17250915 N3715VAlert Rentals LLC · Pleasant Grove, UTBuilt 1975 · S/N 15076597 N3716UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1963 · S/N 18255116 N3716VBorton Garrett J · Newcastle, WYBuilt 1975 · S/N 15076598 N3717FLake Area Technical College · Watertown, SDBuilt 1966 · S/N 17255212 N3717YOwosso Navigators Club LLC · Owosso, MIBuilt 1963 · S/N 21058217 N3718JStewarts Aircraft Service Inc · Waynesville, OHBuilt 1966 · S/N 15065018 N3719DVector Stunts Inc · Bend, ORBuilt 1957 · S/N 34419 N3719JVink Ray · Phoenix, AZBuilt 1966 · S/N 15065019 N3719LHurst Edward E · Southlake, TXBuilt 1965 · S/N 17253888 N3719UOlsen Marvin J · Kent, WABuilt 1963 · S/N 18255119 N3719YG & G Famrs Of Gilbert Inc · Gilbert, LAS/N 21058219 N371CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282001 N371LSatellite Flying Club Inc · East Patchogue, NYBuilt 1970 · S/N 17701488 N371LMMiller Leo S · Chelan, WABuilt 1958 · S/N 36805 N371RHChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10414 N371RSStroberg Roger D · Hutchinson, KSBuilt 1966 · S/N 17254229 N371SRHurt David · Shallotte, NCBuilt 1966 · S/N 17256111 N3720DHarrington Patrick M · Quitman, MSBuilt 1957 · S/N 34420 N3720FRegistration Pending · Chantilly, VARegistration pendingBuilt 1966 · S/N 17255215 N3720LWonsyld Erik · Grants Pass, ORBuilt 1965 · S/N 17253889 N3720SWaddell Stephen Tyler · Summerville, SCBuilt 1963 · S/N 17250920 N3721LFlightmaster Aviation Services Inc · Centerville, INBuilt 1965 · S/N 17253890 N3721RMoran William J · Keller, TXBuilt 1966 · S/N 17255521 N3721UDanko Lawrence G Trustee · Paden, OKBuilt 1963 · S/N 18255121 N3721VMacksamie John M · Rochester, NYBuilt 1975 · S/N 15076600 N3722DSkydive Inc · Eagle Creek, ORBuilt 1957 · S/N 34422 N3722FHutchinson Flying Club LLC · Freeman, SDBuilt 1966 · S/N 17255217 N3722RRegistration Pending · Wallace, NCRegistration pendingS/N 17255522

Back to AD 79-10-14 R1