Skip to content

Registered aircraft · 54,015

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N6161BPeterson Tony D · Humboldt, IABuilt 1957 · S/N 34161 N6161FBeach Bums Air LLC · Martin, GABuilt 1968 · S/N 21059061 N6161GGough James L · Hesston, KSBuilt 1969 · S/N 15071661 N6161KSmith William F · Hindsville, ARBuilt 1975 · S/N 15077562 N6161NOn Eagles Wings LLC · Los Gatos, CABuilt 1978 · S/N 21062932 N6161STeklinski Andrew · Indian River, MIS/N R18201633 N61622Lexington Flying Club · Richmond, KYBuilt 1975 · S/N 17264681 N61625Chapline Curtis · Cypress, TXBuilt 1975 · S/N 17264683 N61628Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1974 · S/N 17264684 N6162RSmjd LLC · Penrose, COBuilt 1965 · S/N T210-0062 N61630Jerome Pester Farms Inc · Hingham, MTBuilt 1975 · S/N 17264685 N61631Jones Donald T Jr · Barrigada, GUBuilt 1975 · S/N 17264686 N61632Cost Garret Alan · Tulalip, WABuilt 1976 · S/N 18052785 N61633Rotor Spec Aviation LLC · Fort Lauderdale, FLBuilt 1975 · S/N 17264688 N61635Meridian Aero Club Inc · Midland, MIBuilt 1975 · S/N 17264690 N61637Amelia Reid Aviation LLC · San Jose, CABuilt 1975 · S/N 17264691 N6163FVagabond Flying Association · Winfield, ILBuilt 1979 · S/N 17273157 N6163KJennings Steven W · Austin, TXS/N 15077563 N6163MN6163m LLC · Eugene, ORBuilt 1962 · S/N 17249550 N6163UMcevoy Steven T · Aniak, AKBuilt 1980 · S/N U20605357 N61640Cooper Michael A · Rohnert Park, CABuilt 1975 · S/N 17264694 N61641Handzo Anthony J · Roseville, ILBuilt 1975 · S/N 17264695 N61642N61642 LLC · Lowell, MIBuilt 1975 · S/N 17264696 N61643Spence Stephen E · Mancelona, MIBuilt 1975 · S/N 17264697 N61645Lima-001 LLC · Muscatine, IABuilt 1975 · S/N 17264698 N61648Tnt Airworks LLC · Hibbing, MNS/N 17264699 N6164B64 Bravo LLC · Oberlin, OHBuilt 1957 · S/N 34164 N6164FBlue River Aviation LLC · Palmer, AKBuilt 1979 · S/N 17273158 N6164TRubin Andrew C · Rochester, NHBuilt 1964 · S/N 15060864 N61651Clw Aviation LLC · Springville, ALBuilt 1975 · S/N 17264702 N61653Michel Daniel T · Sterling, AKBuilt 1976 · S/N 18052786 N61655Air Planes LLC · Soddy Daisy, TNBuilt 1975 · S/N 17264704 N61656Dismang Chad C · Boynton, OKS/N 17264705 N61657Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1975 · S/N 17264706 N61658Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 17264707 N61659Bowerman Richard E · Wetmore, MIBuilt 1975 · S/N 17264708 N6165EBailey Frank W · White City, ORBuilt 1958 · S/N 46265 N6165FMainely Lobsters · Gulf Breeze, FLBuilt 1968 · S/N 21059065 N6165GPartida Carlos · Delray Beach, FLBuilt 1969 · S/N 15071665 N61662Huston Stephen M · Hollister, CABuilt 1976 · S/N 18052787 N61663Mohamed Eman Z · Lubbock, TXBuilt 1975 · S/N 17264712 N6166EAshabranner Kevin T · Port Saint Joe, FLBuilt 1958 · S/N 46266 N6166NBrian C Haggerty LLC · Pembroke Pines, FLBuilt 1981 · S/N 18504302 N6166UBb Aviation LLC · Prescott, AZBuilt 1979 · S/N U20605359 N61670Registered aircraftBuilt 1975 · S/N 17264717 N61671Charlotte Flyers Inc · Fort Myers, FLBuilt 1975 · S/N 17264718 N61672American Patrols Inc · Midland, TXBuilt 1975 · S/N 17264719 N61676Vectors LLC · Sterling, VABuilt 1975 · S/N 17264721 N61677Morcom Aviation Services Inc DBA · Everett, WABuilt 1975 · S/N 17264722 N6167BEdwards Darrell R · Artesia, NMBuilt 1957 · S/N 34167

Back to AD 87-20-03 R2