Skip to content

Registered aircraft · 207

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('0630710')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('0630710')
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.

N109RWMcpherson Michael A · Stephenville, TXBuilt 1971 · S/N AA1A-0250 N10FAFlanigan Marie C · Lockport, NYBuilt 1972 · S/N AA1A-0337 N12VGHashimoto Noriyuki · Rumford, MEBuilt 1971 · S/N AA1A-0187 N143RRHale Arthur H · Angleton, TXBuilt 1972 · S/N AA1A-0397 N14FATerran Aviation LLC · Kissimmee, FLBuilt 1972 · S/N AA1A-0366 N15HAPressley Brent R · Morristown, TNBuilt 1972 · S/N AA1A-0425 N160YAnthonson Ronald G · Cortland, NYBuilt 1971 · S/N AA1A-0048 N17APWest David R Jr · Clermont, FLBuilt 1971 · S/N AA1A-0007 N1972AConkle Marc · Madera, CABuilt 1972 · S/N AA1A-0417 N224SSQuesnel Joseph P · Middlebury, VTS/N AA1A-0433 N22WAQuillan Patrick M · Wyoming, MIBuilt 1971 · S/N AA1A-0282 N29RADuenner Matthias · Tustin, CABuilt 1971 · S/N AA1A-0108 N2CAAnderson Paul M · Brandon, MNBuilt 1972 · S/N AA1A-0436 N32MLAnderson Seth A · San Marcos, TXBuilt 1972 · S/N AA1A-0350 N41RCCurtis Craig C · Dacula, GAS/N AA1A-0143 N513BASong Su H · Duluth, GABuilt 1972 · S/N AA1A-0450 N52TN52t LLC · Pleasant Prairie, WIBuilt 1971 · S/N AA1A-0212 N553HBrantley Hugh L · Hazlehurst, GABuilt 1971 · S/N AA1A-0295 N627JSJds-3 LLC · Wesley Chapel, FLBuilt 1971 · S/N AA1A-0142 N6300LHanson Kirk R · Asheboro, NCBuilt 1971 · S/N AA1A-0300 N6304LClemons Thomas · New York, NYBuilt 1971 · S/N AA1A-0304 N6305LBrewe Matthew P · Odessa, MOBuilt 1971 · S/N AA1A-0305 N6307LSheltra Reese Hanna · Margate, FLS/N AA1A-0307 N6309LMauro Diogo T · Little Elm, TXBuilt 1971 · S/N AA1A-0309 N6310LKuczer Ronald R · Chesterfield, MOBuilt 1971 · S/N AA1A-0310 N6315LFletch Air Inc · Comfort, TXBuilt 1971 · S/N AA1A-0315 N6317LVigesaa Ryan · Hazen, NDBuilt 1971 · S/N AA1A-0317 N6322LYoung Douglas Dale · Hopkinsville, KYBuilt 1972 · S/N AA1A-0342 N6332LKnight Billy K · Roseville, CABuilt 1972 · S/N AA1A-0332 N6341LKlassen Henry W · Seminole, TXBuilt 1972 · S/N AA1A-0341 N6344LCheney Dustin S · Phillipsburg, KSBuilt 1972 · S/N AA1A-0344 N6347LMcdonald Brion J · Palo Alto, CABuilt 1972 · S/N AA1A-0347 N6349LFutrell Robert T · Pensacola, FLBuilt 1972 · S/N AA1A-0349 N6352LRegistered aircraftBuilt 1972 · S/N AA1A-0352 N6355LLocklear Steven M · Salina, KSBuilt 1972 · S/N AA1A-0355 N6357LRunway 37 Inc · Hanson, MABuilt 1972 · S/N AA1A-0357 N6358LCross Lloyd D III · Kennesaw, GABuilt 1972 · S/N AA1A-0358 N6359LCole Douglas W · Kennewick, WAS/N AA1A-0359 N6361LDauernheim John M · Henderson, NVBuilt 1972 · S/N AA1A-0361 N6371LKeeling Jonah David · Covington, GABuilt 1972 · S/N AA1A-0371 N6372LSpek Anton L Jr · Black Eagle, MTBuilt 1972 · S/N AA1A-0372 N6375LRose George W Jr · Merrimack, NHBuilt 1972 · S/N AA1A-0377 N6379LNaines David W · Bolton, MAS/N AA1A-0379 N6381LSale Reported · Addison, TXSale reportedS/N AA1A-0381 N6384LStaeheli Brice · Saint Paul, MNBuilt 1972 · S/N AA1A-0384 N6388LMarlette Aviation Inc · Marlette, MIBuilt 1972 · S/N AA1A-0388 N6390LCribbs Joseph T · Panama City, FLBuilt 1972 · S/N AA1A-0390 N6392LNorth Coast Flying Club · Oberlin, OHBuilt 1972 · S/N AA1A-0392 N6398LZurick Garrett · San Antonio, TXBuilt 1972 · S/N AA1A-0398 N6402LHarsh Kevin R · La Junta, COBuilt 1972 · S/N AA1A-0402

Back to American AA-1A