Skip to content

Registered aircraft · 40,471

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-04-03-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-04-03-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-04-03-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-04-03-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-04-03-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-04-03-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.

N8419HHoke William Jr · Charlestown, INBuilt 1981 · S/N 28-8190291 N8419JHammonds Hangars Inc · Wilmington, DEBuilt 1980 · S/N VAC-168-80 N8419RLytle Cole · North Palm Beach, FLS/N 28-22296 N841BKKilpatrick Joseph C · Atlanta, GABuilt 1966 · S/N 28-3255 N841CMTalley-Sickles Jacqueline M · Oxnard, CAFirst renewal noticeBuilt 1969 · S/N 28-5488 N841EDR&D Aviation LLC · Fayetteville, GABuilt 1967 · S/N 28-4273 N841JARicci Theodore J · Spotswood, NJBuilt 1968 · S/N 17256902 N841JWScenic Concepts LLC · La Crosse, WIBuilt 1974 · S/N 17264340 N841NHMarrs Matt · Bentonville, ARBuilt 2020 · S/N P07-16N/17N-P011 N841PGeeslin James W Jr · Sterling, AKBuilt 1985 · S/N 96 N8420CRegistered aircraftBuilt 1976 · S/N 28-7690138 N8420DAlsworth Glen R Sr · Port Alsworth, AKBuilt 1958 · S/N 22-5675 N8420JGimple Herman Wm · Greenville, CABuilt 1980 · S/N VAC-169-80 N8420LHayhurst Shane R · Winfield, PABuilt 1968 · S/N 17256620 N8420RMueller Lance · Milton, DEBuilt 1966 · S/N 28-22349 N8420WMckee Shane D · Fairbanks, AKS/N 28-2647 N8420YVanwarmerdam Leslie C · Nampa, IDS/N 18-8862 N84210Pm Jets LLC · Ashland, OHBuilt 1969 · S/N 17258380 N84214Planefully Obvious LLC · Oshkosh, WIBuilt 1969 · S/N 17258382 N8421DPutman Bruce C · Leonard, MIBuilt 1957 · S/N 22-5676 N8421JRegistered aircraftBuilt 1980 · S/N VAC-166-80 N8421RRoberts Darren C · Zionsville, INBuilt 1966 · S/N 28-22298 N84221Mcknight Michael D · Marietta, GABuilt 1969 · S/N 17258384 N84224Cordes Jeffrey A · Happy Valley, ORBuilt 1969 · S/N 17258386 N84225Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17258387 N84226Jackson County Aviation LLC · Sneads, FLBuilt 1969 · S/N 17258388 N84227Jernigan Alex E · Warrensburg, MOBuilt 1981 · S/N 28-8190298 N84229Langenbahn Theodore John · Schoharie, NYBuilt 1969 · S/N 17258389 N8422HDeevers Howard A · Tucson, AZBuilt 1981 · S/N 28-8116292 N8422LHubert Kim J Trustee · Eagle River, AKBuilt 1968 · S/N 17256622 N8422NCenter Flying Inc · Lancaster, CABuilt 1981 · S/N 28-8190296 N8422RTascarella William M · Quakertown, PABuilt 1966 · S/N 28-22299 N8422W642 Flying Club Of Fort Worth Inc · Fort Worth, TXBuilt 1965 · S/N 28-2649 N84234Mazelg Aviation LLC · Bartow, FLBuilt 1969 · S/N 17258390 N8423DKearney Rick G · Amity, PABuilt 1957 · S/N 22-5678 N8423LYoung James A · Toledo, WAS/N 17256623 N8423WGillanders Kenneth William · Carson City, NVBuilt 1965 · S/N 28-2650 N8424Huston Charles D · Austin, TXBuilt 1974 · S/N AGE-150 N84243Sjoberg Donald E · Poteau, OKBuilt 1969 · S/N 17258393 N8424LMcgreen John R · Albany, NYBuilt 1968 · S/N 17256624 N84250Wick James R · Canon City, COBuilt 1969 · S/N 17258395 N84256Registered aircraftBuilt 1969 · S/N 17258396 N8425FSons Aviation LLC · Moody, ALBuilt 1976 · S/N 28-7715259 N8425WBenner James R · Goshen, INBuilt 1965 · S/N 28-2652 N84265West Gerald Lee · Two Harbors, MNBuilt 1969 · S/N 17258399 N84267Shields Debra M · York, SCBuilt 1969 · S/N 17258400 N8426POta Paul T · Grayslake, ILBuilt 1964 · S/N 24-3674 N8426RBryant Bryce E · Evans City, PABuilt 1966 · S/N 28-22303 N84271Anderson Operations LLC · Fallon, NVBuilt 1969 · S/N 17258402 N84275Rodriguez Norberto R · Inwood, NYBuilt 1969 · S/N 17258404

Back to AD 80-04-03 R2