Skip to content

Registered aircraft · 26,231

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

N53222Pacific Valley Aviation Inc · Arbuckle, CABuilt 1945 · S/N 8627 N5322TChase 13 LLC · Wilmington, DES/N 17251222 N5323CManley Eugene M II · Raleigh, NCBuilt 1950 · S/N 15443 N5323PCarls Phillip G · Frederick, MDBuilt 1972 · S/N 15073223 N5323ROld Grove Aviation LLC · Port Charlotte, FLBuilt 1965 · S/N 17252848 N5323TKnueven Timothy P · Brownsboro, ALS/N 17251223 N5325QIlm Aviation LLC · Waxahachie, TXBuilt 1972 · S/N 15073225 N5325RBardo Daniel J · Salem, OHBuilt 1965 · S/N 17252850 N5327QLarsen Deziree L · Bay Point, CABuilt 1972 · S/N 15073227 N5327RMcgrath John J · Littleton, COBuilt 1965 · S/N 17252852 N5327TMurphy Shane T · Bird Creek, AKBuilt 1964 · S/N 17251227 N5328CLewis George F Jr · Hampton, CTBuilt 1950 · S/N 15448 N5328TDiem James L · Kiel, WIBuilt 1964 · S/N 17251228 N5329CVetterli Gary R · Monroe, WIBuilt 1950 · S/N 15449 N5329RDearborn Flying Club Inc · Grosse Pt Shr, MIBuilt 1965 · S/N 17252855 N5329TShort Kenneth L · Setauket, NYBuilt 1964 · S/N 17251229 N533Davis Gary W · Denton, TXBuilt 2021 · S/N 20814 N5330QBend Aircraft Mechanics LLC · Bend, ORBuilt 1972 · S/N 15073230 N5330TMilne Sales And Services LLC · Lake Geneva, WIBuilt 1964 · S/N 17251230 N5331RHastings Peter D · Bar Harbor, MEBuilt 1965 · S/N 17252857 N5332CReed Ralph R · San Marcos, CABuilt 1950 · S/N 15452 N5332RJohnson Michael Hans · Tuttle, NDBuilt 1965 · S/N 17252858 N5333CWinkler Aircraft Leasing Inc · Brush, COBuilt 1950 · S/N 15453 N5333TParkison Leland Cameron · Battle Ground, WABuilt 1967 · S/N 17256100 N5334CSnyder Kenneth C · Lonsdale, MNBuilt 1950 · S/N 15563 N5334RDasilva Jonathan L · Madera, CABuilt 1965 · S/N 17252861 N5334TBarker Charles W Jr · Collinsville, OKBuilt 1964 · S/N 17251234 N53350Conner Michael J · Scotts Valley, CABuilt 1965 · S/N 17252862 N5338QFly By Knight LLC · Louisville, KYBuilt 1972 · S/N 15073238 N5338TKidd Cody M · Martinsville, OHS/N 17251238 N533VEWagner Robert J · Dubuque, IABuilt 1981 · S/N 1533 N533ZRobinson Carl · Longview, TXBuilt 1980 · S/N 272 N5340CCustis James G · Friday Harbor, WABuilt 1950 · S/N 15460 N5340TRundell Lanny · Winnsboro, LABuilt 1964 · S/N 17251240 N5342CPig Aero LLC · Aurora, ILBuilt 1950 · S/N 15565 N5343RMcmahon Michael E · Porterfield, WIBuilt 1965 · S/N 17252871 N5344CThomas Robert S · Caddo Mills, TXBuilt 1948 · S/N 18529 N5344QGraber Quinten R · Brooksville, MSS/N 15073244 N5344RMoxley Michael D · Spearfish, SDBuilt 1965 · S/N 17252872 N5345QRegistered aircraftBuilt 1972 · S/N 15073245 N5345TBerrong Jimmy L Sr · Dahlonega, GABuilt 1964 · S/N 17251245 N5346QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1972 · S/N 15073246 N5349RTroya Aviation LLC · Utica, NYBuilt 1965 · S/N 17252878 N53500Burt Charley R · Anchorage, AKBuilt 1942 · S/N 3394 N5350CJones Terry M · Bells, TNBuilt 1950 · S/N 15573 N5350RNorth Fergus Flying Club · Winifred, MTBuilt 1965 · S/N 17252879 N5351CLc Aviation Consulting LLC · Montauk, NYBuilt 1950 · S/N 15482 N5352CBohl Howard M · Temecula, CABuilt 1950 · S/N 15483 N5352RProam Flyers Of Union County · Matthews, NCBuilt 1965 · S/N 17252882 N5352TFord Howard J · Salt Lake City, UTBuilt 1964 · S/N 17251252

Back to AD 94-05-05 R1