Skip to content

Registered aircraft · 6,349

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:80-25-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2') 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:80-25-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
  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:80-25-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
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.

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 N63628Black Hills Airplanes LLC · Rapid City, SDBuilt 1981 · S/N 17275458 N6367Makino Kazuya · Fountain Valley, CAS/N 56 N6367QCc Aviation Inc · Tracy, CABuilt 1981 · S/N 15285236 N6368QRegistration Pending · Kalispell, MTRegistration pendingS/N 15285237 N6371LKeeling Jonah David · Covington, GABuilt 1972 · S/N AA1A-0371 N6372LSpek Anton L Jr · Black Eagle, MTBuilt 1972 · S/N AA1A-0372 N6375HRound Engine Aero · Nashville, MIS/N 15284162 N6375LRose George W Jr · Merrimack, NHBuilt 1972 · S/N AA1A-0377 N6376MMattingly Eddie D · Port Charlotte, FLBuilt 1980 · S/N 15284698 N6377BMarsicano Robert M · Danbury, CTBuilt 1979 · S/N 15283926 N6378MFlowers Jonathan Barak · Kent, WABuilt 1980 · S/N 15284700 N6379LNaines David W · Bolton, MAS/N AA1A-0379 N6381LSale Reported · Addison, TXSale reportedS/N AA1A-0381 N6381NSutherland David D · Delta Junction, AKBuilt 1967 · S/N 451 N6382NHamptonville Aviation LLC · Hamptonville, NCBuilt 1967 · S/N 388 N6383NCarino Jane L · Buckley, WABuilt 1967 · S/N 302 N6384LStaeheli Brice · Saint Paul, MNBuilt 1972 · S/N AA1A-0384 N6384NWaggener Chris E · Adelanto, CABuilt 1967 · S/N 381 N6387BSparrow Hawk Aviation LLC · Moraine, OHBuilt 1979 · S/N 15283927 N6387NRobert Fuoss Inc · Draper, SDBuilt 1967 · S/N 518 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 N6392NPritchett Joe H · Dyersburg, TNS/N 353 N6397AJasinski John H · Yukon, OKBuilt 1978 · S/N 38-78A0412 N6397NLafleur Gregory J · Eunice, LABuilt 1967 · S/N 356 N6398BHanson Charlotte A · Palmer, AKBuilt 1946 · S/N 12-382 N6398LZurick Garrett · San Antonio, TXBuilt 1972 · S/N AA1A-0398 N6398PShelton Dale E · West Frankfort, ILBuilt 1981 · S/N 15285011 N63ANNugent Alasdair · Mount Ephraim, NJS/N 1543 N63BCValleortiz Hector J · Laurel Hill, NCBuilt 1968 · S/N 637 N63MKPeterson Grant · Mclean, VABuilt 2000 · S/N 20-0051 N63RWSmith Jacques F · Anchorage, AKBuilt 1978 · S/N 15280763 N6400QHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15285244 N6402LHarsh Kevin R · La Junta, COBuilt 1972 · S/N AA1A-0402 N6403MPlane N Simple Aviation LLC · Los Angeles, CABuilt 1980 · S/N 15284711 N6405LKoster Mark W · Amarillo, TXBuilt 1972 · S/N AA1A-0405 N6406HRizzo John Jr · Dunnellon, FLBuilt 1946 · S/N 19587 N6407LVetter Johnathon A · Moundridge, KSFirst renewal noticeBuilt 1972 · S/N AA1A-0407 N6409LKirkpatrick Joshua · Cleburne, TXBuilt 1972 · S/N AA1A-0409 N6409MCendejas Agustin · Chino, CABuilt 1980 · S/N 15284713 N6412LRichie John W · Murfreesboro, TNBuilt 1972 · S/N AA1A-0412 N6412MNighthawk N8231g LLC · Pompano Beach, FLS/N 15284715 N6413LBoykin Dennis B IV · Leesburg, VABuilt 1972 · S/N AA1A-0413 N6416LRegistration Pending · Crosby, MNRegistration pendingBuilt 1972 · S/N AA1A-0416 N6419LHaag Jay E · Mason City, IABuilt 1972 · S/N AA1A-0419 N6419MWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284718

Back to AD 80-25-02 R2