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.

N49230US Flight Academy International Inc DBA · Post, TXBuilt 1977 · S/N 15281205 N4923ZWeigel Martin C · Valley City, OHBuilt 1961 · S/N 22-8511 N49249Krawczak Kyle C · Littleton, COBuilt 1979 · S/N 15283442 N4924ZGlover Thomas B · Marana, AZBuilt 1961 · S/N 22-8514 N4925ZKopacz Thomas H · Glen Flora, WIS/N 22-8515 N49260Youth Aeronautics Education Foundation · Mattaponi, VABuilt 1977 · S/N 15281209 N49261Salem Oregon Flight Training LLC · Salem, ORBuilt 1977 · S/N 15281210 N49268Fox John E · Boonville, CABuilt 1977 · S/N 15281213 N49276Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281217 N4927BAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283709 N49285Fullerton Airport Pilot Association · Fullerton, CABuilt 1979 · S/N 15283445 N49288Wisconsin Aviation Inc · Watertown, WIBuilt 1977 · S/N 15281226 N4928BWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283710 N49292Johnson Scott W · Saline, MIS/N 15283446 N4929ZDennis Robert · Rosamond, CAS/N 22-8519 N4930BSkyranch Knoxville Youth Inc · Knoxville, TNS/N 15283712 N4930HSantillan Hannah M · Belgrade, MTBuilt 1948 · S/N 11-802 N4931BWojtowicz Tomasz · Bronx, NYBuilt 1979 · S/N 15283713 N4931ZThurmond Kenneth · Eastover, NCS/N 22-8521 N49328Air Puerto Rico Corp · Aguadilla, PRFirst renewal noticeBuilt 1979 · S/N 15283448 N4932ZWilczynski John J · Lake Village, INBuilt 1961 · S/N 22-8524 N4933ZSale Reported · Clio, MISale reportedS/N 22-8525 N49341Dale Michael E · Murrieta, CABuilt 1979 · S/N 15283449 N4936ZDomeyer Daylen K · Cincinnati, OHS/N 22-8528 N4937PMorcom Aviation Services Inc · Everett, WABuilt 1981 · S/N 15284849 N49387Old Aire LLC · Bellingham, WAS/N 5-1493 N4938HAir Poueir LLC · Amarillo, TXBuilt 1979 · S/N 15284033 N49404Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281240 N49417Rich John E · Dunnellon, FLS/N 15281248 N49419Ds Flight Services LLC · Battle Ground, WAS/N 15281250 N49423Johnson Shem E · Bonners Ferry, IDBuilt 1978 · S/N 15281254 N49424Xin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15281255 N4942HFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1979 · S/N 15284036 N49432Northshore Group LLC · Wilmington, DEBuilt 1978 · S/N 15281262 N49434California In Nice Inc · San Jose, CABuilt 1979 · S/N 15283458 N49438Crickmer Charles C · Overton, NVBuilt 1978 · S/N 15281267 N49439Wisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1978 · S/N 15281268 N4943LBonus Kurt · Wind Lake, WIBuilt 1980 · S/N 15284245 N4943ZBlackford Robert G · Mt Airy, MDBuilt 1961 · S/N 22-8538 N49447Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281274 N4944ZHoppes Larry J · Springville, INBuilt 1961 · S/N 22-8540 N49455Above All Aviation Inc · Goleta, CABuilt 1978 · S/N 15281281 N4945ZWillis James · Pelham, ALBuilt 1961 · S/N 22-8541 N49461Blue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 15281287 N49471Aeroquest LLC DBA · Olive Branch, MSBuilt 1978 · S/N 15281294 N4947ZSatreaas Kenneth A · Verona, NDBuilt 1961 · S/N 22-8543 N4948ZSenn Joshua · Depauw, INBuilt 1961 · S/N 22-8545 N4949ZPeeples Ryan · Folkston, GABuilt 1961 · S/N 22-8546 N4950AShaffer Barbara J · Franklin, KYS/N A1520910 N4951A152 University LLC · Blacksburg, VABuilt 1979 · S/N A1520911

Back to AD 80-25-02 R2