Skip to content

Registered aircraft · 59

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:62-02-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:62-02-06') 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:62-02-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:62-02-06')
  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:62-02-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:62-02-06')
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.

N150PPBurghduff Aviation LLC · Ludlow, SDS/N 25-23 N337ABPlane And Simple Leasing LLC · Delano, MNBuilt 1960 · S/N 25-459 N37ABPlane And Simple Leasing LLC · Delano, MNBuilt 1960 · S/N 25-340 N4477PAirknocker Inc · Wilmington, DEBuilt 1960 · S/N 25-253 N6016ZPrestenbach Kyle A · Vacherie, LAS/N 25-19 N6021ZAerial Banners Inc · Pembroke Pines, FLS/N 25-25 N6035ZAerial Banners Inc · Pembroke Pines, FLBuilt 1959 · S/N 25-42 N6047ZValley Soaring Club · Middletown, NYBuilt 1959 · S/N 25-54 N6049ZLockwood Shawn O · Volborg, MTBuilt 1959 · S/N 25-56 N6052ZJackson Paul D · Phoenix, AZBuilt 1959 · S/N 25-59 N6053ZSlack Brenda · Norfolk, VABuilt 1959 · S/N 25-60 N6058ZBlackstone Aircraft LLC · Hartselle, ALBuilt 1960 · S/N 25-18 N6079ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-91 N6112ZLowry Wilson R · Leonardtown, MDBuilt 1960 · S/N 25-130 N6120ZH & H Ag Aviation Inc · New Underwood, SDBuilt 1960 · S/N 25-140 N6125ZSvendsen Jon A · Wasilla, AKBuilt 1960 · S/N 25-145 N6126ZKistler Stephen M · Monument, KSBuilt 1960 · S/N 25-147 N6127ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-148 N6140ZConnecticut Soaring Association Inc · New London, CTS/N 25-164 N6141ZRotor And Wing · Tioga, NDBuilt 1960 · S/N 25-165 N6151ZRotor And Wing LLC · Tioga, NDBuilt 1960 · S/N 25-177 N6175ZSpot-Air LLC · Burlington, TXBuilt 1959 · S/N 25-208 N6189ZHall William B · Vincentown, NJBuilt 1960 · S/N 25-223 N6196ZH&H Ag-Aviation Inc · New Underwood, SDBuilt 1960 · S/N 25-230 N6200ZAerial Banners Inc · Pembroke Pines, FLBuilt 1960 · S/N 25-234 N6203ZKnutson Wayne R · Tioga, NDBuilt 1960 · S/N 25-241 N6208ZBenz Aviation LLC · Ionia, MIBuilt 1960 · S/N 25-246 N6218ZLorenzo Ag Air Inc DBA · Lorenzo, TXBuilt 1960 · S/N 25-258 N6225ZBriner Mark E · Utica, KYBuilt 1963 · S/N 25-273 N6238ZDrake Aerial Enterprises LLC DBA · Genoa, OHBuilt 1960 · S/N 25-289 N6239ZQuickflight LLC · Mazomanie, WIBuilt 1960 · S/N 25-290 N6260ZAerial Banners North Inc · Pembroke Pines, FLBuilt 1960 · S/N 25-321 N6264ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-326 N6265ZAerial Banners Inc · Pembroke Pines, FLBuilt 1960 · S/N 25-327 N6266ZLinzel Jesse Gray Jr · Southern Pines, NCBuilt 1960 · S/N 25-329 N6267ZGordon Strom B Jr · Paris, TXBuilt 1960 · S/N 25-332 N6268ZKnutson Wayne R · Tioga, NDBuilt 1960 · S/N 25-333 N6279ZFlint River Soaring LLC · Bainbridge, GABuilt 1960 · S/N 25-346 N6291ZBordelon Thomas D · Elephant Butte, NMBuilt 1960 · S/N 25-361 N6304ZVintage Aero Sports LLC · Easton, PABuilt 1960 · S/N 25-388 N6319ZSouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1960 · S/N 25-412 N6355ZQuality Aviation Inc · Marana, AZBuilt 1961 · S/N 25-519 N6384ZNeal Aviation Inc · Staples, MNBuilt 1961 · S/N 25-506 N6385ZDoyle Danny G · Mckinney, TXS/N 25-508 N6387ZJ T D LLC · North Platte, NES/N 25-510 N6432ZHamlin Timothy S · Bunker Hill, KSBuilt 1961 · S/N 25-585 N6447ZH&H Ag Aviation Inc · New Underwood, SDBuilt 1961 · S/N 25-607 N6454ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1961 · S/N 25-638 N6456ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1961 · S/N 25-639 N6462ZMinden Soaring Club Inc · Minden, NVBuilt 1962 · S/N 25-661

Back to AD 62-02-06