Skip to content

Registered aircraft · 930

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-14-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-14-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-14-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-14-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-14-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-14-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.

N2343FRegistration Pending · Wickenburg, AZRegistration pendingBuilt 1964 · S/N 21058543 N2346FNavion Holdings LLC · Boise, IDBuilt 1964 · S/N 21058546 N2349FMilutinovic Christain · Marengo, ILBuilt 1964 · S/N 21058549 N2351FStewart Anthony D · Blytheville, ARBuilt 1964 · S/N 21058551 N2357FBachand Kevin L · Leesburg, VABuilt 1964 · S/N 21058557 N2358FEast County Communications Inc · Hurricane, UTBuilt 1965 · S/N 21058558 N2359FSheldon David E Trustee · Idaho Falls, IDBuilt 1964 · S/N 21058559 N2363FColumbus State Community College · Columbus, OHBuilt 1964 · S/N 21058563 N2364FCarlson David G Trustee · Cape Fair, MOBuilt 1964 · S/N 21058564 N2373FRlo Aviation LLC · Double Springs, ALBuilt 1965 · S/N 21058573 N2377FBuoni Frank · Bakersfield, CABuilt 1965 · S/N 21058577 N2381FOops LLC · Cheyenne, WYBuilt 1965 · S/N 21058581 N2383YAult Stanley K · Cinebar, WABuilt 1965 · S/N 21058583 N2387FMitten Daniel L · Hatfield, PABuilt 1965 · S/N 21058587 N2391FBlue Horizon Consulting LLC · Toccoa, GABuilt 1965 · S/N 21058591 N2392FDingo Aviation LLC · Kalispell, MTBuilt 1965 · S/N 21058592 N2393FGreengo Aviation LLC · Temple, TXBuilt 1965 · S/N 21058593 N2394FN2394 Fox LLC · Sapulpa, OKBuilt 1965 · S/N 21058594 N2396FFlippin Birds Aviation LLC · Mobile, ALBuilt 1965 · S/N 21058596 N2398FHorizon Flying LLC · Wilmington, DEBuilt 1965 · S/N 21058598 N2399FJordan Danny L · Medford, ORBuilt 1965 · S/N 21058599 N240MMFlood Specialists Group Inc · Des Plaines, ILBuilt 1960 · S/N 57168 N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563 N242VPirshafiey Nasser Charles · Trabuco Canyon, CABuilt 1965 · S/N T210-0004 N244HEDubin David A · Tucson, AZS/N 21058990 N24KWright Douglas J · Greenwood, INBuilt 1960 · S/N 57265 N2573QJayviation Inc · Lake City, FLBuilt 1969 · S/N 21059173 N25JCAvg LLC · Chico, CABuilt 1959 · S/N 57008 N2747VDavis Brady L · Monument, COS/N 21058458 N2852SLudian Malgorzata · Bakersfield, CAS/N 21058974 N296BJQualitair LLC Trustee · MichelstadtBuilt 1965 · S/N 21058697 N2KDElliott Frank F · Mojave, CABuilt 1969 · S/N T210-0436 N302GPInternational Air Services Inc Trustee · Carson City, NVS/N 21058682 N302STManagement Support Services LLC · Naturita, COBuilt 1968 · S/N T210-0350 N30444Crapnell Mark · Huntington Beach, CAS/N 210-58861 N321CHSmith James Christian · Rockport, TXBuilt 1962 · S/N 21058061 N3309SCessna 210 N3309s LLC · Yellville, ARBuilt 1969 · S/N 21059109 N3311SExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1969 · S/N 21059111 N3312SBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059112 N3327SDavis Blake A · Bellevue, TXS/N 21059127 N3336SVancil Todd · Justin, TXBuilt 1969 · S/N 21059136 N3337SBeery Bruce M · Lakeland, FLBuilt 1969 · S/N 21059137 N3340SRegistration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 21059140 N3345SSummit Foundry Systems Inc · Fort Wayne, INBuilt 1969 · S/N 21059145 N3347SArmitage Justin Marc · Hugoton, KSBuilt 1969 · S/N 21059147 N3350SBarry Jason J · Orange, CABuilt 1969 · S/N 21059150 N3351STarantino Nicholas T Jr · Union City, CAS/N 21059151 N3356SBbt Inc · Wilmington, DEBuilt 1969 · S/N 21059156 N3360SMohler Earl C · Bonita, CAS/N 21059160 N3364SAir Deeken Ltd · Doylestown, OHBuilt 1969 · S/N 21059164

Back to AD 76-14-07 R2