Skip to content

Registered aircraft · 25,369

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-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N78219Testa Christopher · Kennesaw, GAFirst renewal noticeBuilt 1968 · S/N 17257532 N78221Waldrop Floyd D · Robinson, ILBuilt 1968 · S/N 17257534 N78228Lanning Keith L · Everton, ARBuilt 1968 · S/N 17257537 N7822VBarry John J · Bethel, CTBuilt 1964 · S/N 2806 N78239Draco Flight School DBA · Chino, CABuilt 1968 · S/N 17257540 N7823GAmerican Patrols Inc · Midland, TXBuilt 1970 · S/N 17259523 N7823VNelson Brent E · Richland, WABuilt 1964 · S/N 445 N78240Kinney Joan M · Vermillion, SDBuilt 1968 · S/N 17257541 N78242176fps LLC · Marthasville, MOBuilt 1968 · S/N 17257543 N78249Howard Ronald W · Okeechobee, FLBuilt 1968 · S/N 17257545 N7824VLyon Timothy P · Kansas City, MOBuilt 1964 · S/N 446 N78253Chatman Hannah K · Poplar Bluff, MOS/N 17257546 N78254Bpk Holdings LLC · Montesano, WABuilt 1968 · S/N 17257547 N7825VHenderson Randy G · Williamstown, WVBuilt 1964 · S/N 447 N7826681 Escadrille Inc · Hutchinson, KSBuilt 1968 · S/N 17257549 N7826VUse Your Call Sign Holdings LLC · Kalispell, MTBuilt 1964 · S/N 448 N7827VJaffe Michael R · Terrell, TXBuilt 1964 · S/N 449 N78286Marsh David J · Sioux Falls, SDBuilt 1968 · S/N 17257554 N7828VHam Henry P · Saint Louis, MOBuilt 1964 · S/N 450 N78295Cofsky Gregory J · Sandwich, MABuilt 1968 · S/N 17257556 N78299Jb Aircraft LLC · Anchorage, AKBuilt 1968 · S/N 17257558 N7829GKilo Sierra Aviation LLC · Sammamish, WAS/N 17259529 N7829VAirdad LLC · Houston, TXBuilt 1964 · S/N 451 N782DJLeandro Eduardo · Orrtanna, PAS/N 24-1592 N782FMFmfa Inc · Wilmington, DEBuilt 1981 · S/N 17274667 N782RGL-Bird LLC · Hood River, ORBuilt 1978 · S/N R18200194 N782SNKingdom Air Corps · Sutton, AKBuilt 1973 · S/N 17261341 N78302Gardner Christopher · South Saint Paul, MNBuilt 1968 · S/N 17257559 N78303Citizen Air LLC · Port Angeles, WABuilt 1968 · S/N 17257560 N78305Woollen Claude D · Moore, SCBuilt 1968 · S/N 17257562 N7830GSkildum&Company LLC · Grand Marais, MNBuilt 1970 · S/N 17259530 N78312Roemer Joanne · Kemah, TXS/N 17257565 N7832VBaker Benjamin D · Catasauqua, PAS/N 2935 N78330Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257567 N78331Clifton Jack D · La Junta, COS/N 17257568 N78332Albright John T · Decatur, ALBuilt 1968 · S/N 17257569 N78335Marotte David J · Windham, NHBuilt 1968 · S/N 17257570 N78338Mbh Aviation LLC · Tulalip, WABuilt 1968 · S/N 17257572 N78339Hopfmann Alwin E · Rutland, MABuilt 1968 · S/N 17257573 N7833GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259533 N78341Davis Glenn A · Fair Oaks, CABuilt 1968 · S/N 17257575 N78349Raker Theodore B · Hahira, GABuilt 1968 · S/N 17257578 N7834GSmith Perry L · Brook Park, MNS/N 17259534 N7834VMorris Tommy R · Houston, TXBuilt 1964 · S/N 2870 N78351Caron John · Ellsworth, MIBuilt 1968 · S/N 17257579 N78354Tonar Richard J Jr · Omaha, NES/N 17257581 N78355Fleming Gary R · Wickliffe, KYBuilt 1968 · S/N 17257582 N78358All American Aviation LLC · Fort Worth, TXS/N 17257585 N78359Burns Stanley R · Flagler, COBuilt 1968 · S/N 17257586 N78367Dardis Barry J · Great Falls, MTBuilt 1968 · S/N 17257587

Back to AD 80-25-07 R1