Skip to content

Registered aircraft · 99

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:76-05-07-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:76-05-07-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:76-05-07-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:76-05-07-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:76-05-07-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:76-05-07-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.

N57721Goltz Aviation LLC · Pembina, NDBuilt 1975 · S/N 36-7660044 N57725Bretts Spray Service Inc · Onida, SDBuilt 1975 · S/N 36-7660047 N57738Quality Aviation Inc · Marana, AZBuilt 1975 · S/N 36-7660054 N57746Aircraft Montana LLC · Helena, MTBuilt 1976 · S/N 36-7660059 N57749Registered aircraftSale reportedBuilt 1976 · S/N 36-7660065 N57751Wood Flying Inc · Panhandle, TXBuilt 1976 · S/N 36-7660058 N57758Aero Spraying Service Inc · Williston, NDS/N 36-7660072 N57772Deterding Jim · Pond Creek, OKBuilt 1976 · S/N 36-7660079 N57775Snyder Spraying Serv Inc · Snyder, OKBuilt 1976 · S/N 36-7660089 N57784Whitlock Holdings LLC · Honey Grove, TXBuilt 1976 · S/N 36-7660095 N57816North Texas Dusters & Sprayers Inc · Gainesville, TXS/N 36-7660122 N57824West Central Ag-Air Inc · Fergus Falls, MNBuilt 1976 · S/N 36-7660132 N57830Mid Continent Aircraft Corp · Hayti, MOBuilt 1977 · S/N 36-7760003 N57832Sherer Robert O · Hayes, SDBuilt 1977 · S/N 36-7760005 N57834Aircraft Montana LLC · Helena, MTS/N 36-7760006 N57846Boardman Air Services LLC · Henderson, NEBuilt 1977 · S/N 36-7760017 N57859Airmotive Service LLC · Brigham City, UTBuilt 1977 · S/N 36-7760029 N57882Dakota Air Spray LLC · Huron, SDBuilt 1977 · S/N 36-7760044 N57886Bernstein Timothy D · Faith, SDBuilt 1977 · S/N 36-7760048 N59652Aircraft Montana LLC · Helena, MTBuilt 1977 · S/N 36-7760061 N59654Quality Aviation Inc · Marana, AZS/N 36-7760064 N59669Sidney Morgan D · Gloucester, VAS/N 36-7760078 N59678L&M Decuir Inc · Cottonport, LABuilt 1977 · S/N 36-7760090 N59681Aircraft Montana LLC · Helena, MTBuilt 1977 · S/N 36-7760094 N59683Gleason Franklin R · Darlington, SCBuilt 1977 · S/N 36-7760097 N6166BSides Michael E · Bartley, NEBuilt 1979 · S/N 367960041 N6174ADakota Air Spray LLC · Huron, SDS/N 36-8102016 N65310Glover Thomas B · Marana, AZBuilt 1975 · S/N 36-7560047 N76400Horning Air LLC · Cresbard, SDBuilt 1976 · S/N 36-7660096 N82646Downs Ricky R Trustee · Roundup, MTS/N 36-7760127 N82656Souther Field Aviation Inc · Americus, GABuilt 1977 · S/N 36-7760134 N82688Wells Flying Services LLC · Holdrege, NEBuilt 1977 · S/N 36-7960043 N82692Piper Aircraft Inc · Vero Beach, FLBuilt 1977 · S/N 36-7960044 N9900PWhitley Aviation LLC · Altoona, ALBuilt 1975 · S/N 36-7560002 N9901PWilliams Fertilizer Services LLC · Oregon, MOBuilt 1975 · S/N 36-7560003 N9904PRose Dale · Americus, GABuilt 1975 · S/N 36-7560007 N9911PMid Continent Aircraft Corp · Hayti, MOBuilt 1975 · S/N 36-7560019 N9914PCounty Of Galveston · Dickinson, TXBuilt 1975 · S/N 36-7560022 N9923PMundell Terry D Trustee · Rosston, OKBuilt 1975 · S/N 36-7560033 N9928PQuality Aviation Inc · Marana, AZS/N 36-7560039 N9938PHeartland Aviation Inc · Alliance, NEBuilt 1975 · S/N 36-7560050 N9947PQuality Aviation Inc · Marana, AZBuilt 1975 · S/N 36-7560058 N9957PPennsylvania College Of Technology · Williamsport, PABuilt 1975 · S/N 36-7560068 N9964PCabbage Kenneth S · Prosser, WABuilt 1975 · S/N 36-7560075 N9966PGrubbs Terry L DBA · Gregory, SDBuilt 1975 · S/N 36-7560077 N9976PSides Aviation LLC · Cambridge, NEBuilt 1975 · S/N 36-7560089 N9979PFederal Aerial Applicators LLC · Wilmington, DEBuilt 1975 · S/N 36-7560092 N9981PButler Billy D · Hilger, MTBuilt 1975 · S/N 36-7560095 N9996PMid Continent Aircraft Corp · Hayti, MOS/N 36-7560097

Back to AD 76-05-07 R2