Skip to content

Registered aircraft · 20,483

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N3192UColonial Aviators LLC · Williamsburg, VABuilt 1962 · S/N 18254592 N3192YArea 52 Aviation LLC · Casper, WYBuilt 1962 · S/N 18254192 N3193DOrth Henry J · Wasilla, AKBuilt 1955 · S/N 31991 N3193FJcd4 Capital LLC · Birmingham, ALS/N 18257293 N3193RHolmes John H · Barto, PABuilt 1967 · S/N 18258593 N3193SHansen Arthur A · Lancaster, NYBuilt 1964 · S/N 18255693 N3193YDavis Loyal A · Santa Rosa, CABuilt 1962 · S/N 18254193 N3194DMatthews James B · Wills Point, TXBuilt 1955 · S/N 31992 N3194YSchexnayder Jennifer · New Roads, LABuilt 1962 · S/N 18254194 N3195DRegistration Pending · Fort Mohave, AZRegistration pendingBuilt 1955 · S/N 31993 N3195ECatlett John W · Briggsville, ARBuilt 1982 · S/N 18268238 N3195RPalmer Matthew B · Riverside, CABuilt 1967 · S/N 18258595 N3195UHinton Jake B · Mcdonough, GABuilt 1963 · S/N 18254595 N3195YFlyers Above The Payette LLC · Mccall, IDBuilt 1962 · S/N 18254195 N3196CWeir Ryan L · Buckley, WABuilt 1954 · S/N 30995 N3196RS & S Aviation Co · Ball Ground, GAS/N 18258596 N3196SHistoricair Transport LLC · Midlothian, TXS/N 18255696 N3196YRickles Richard J · Chamblee, GABuilt 1962 · S/N 18254196 N3197CScott James D · Mesa, AZBuilt 1954 · S/N 30996 N3197FWhite River Land And Timber Co LLC · Greenbrier, ARBuilt 1966 · S/N 18257297 N3197SJarvis Jason O · Cresson, TXBuilt 1964 · S/N 18255697 N3197YMonahan Robert J · Bulverde, TXBuilt 1962 · S/N 18254197 N3198YKembel Cary A · Snyder, COBuilt 1962 · S/N 18254198 N3199CGreenleaf Michael G · Tacoma, WAFirst renewal noticeBuilt 1954 · S/N 30998 N3199RUmina Michael P · Hopkinton, MABuilt 1967 · S/N 18258599 N3199UNiner Niner Uniform LLC · Elk Mound, WIBuilt 1963 · S/N 18254599 N3199YClearwater Valley Aero Club Inc · Kamiah, IDBuilt 1962 · S/N 18254199 N319JFRegistration Pending · Johns Island, SCRegistration pendingS/N 21063507 N319KSFvx Research · Manassas, VABuilt 2010 · S/N 18282243 N319MTSimply Living LLC · Fort Myers, FLS/N 31438 N31ABEtanrith Consulting LLC · Sheldon, SCBuilt 2021 · S/N 18283143 N31AJ1 Alpha Jadzia LLC · Fort Worth, TXBuilt 1975 · S/N 18264449 N31BBohon Todd R · Palmer, AKS/N 18052431 N31DDDavis David C · Queen Creek, AZBuilt 1960 · S/N 52836 N31KEWilcox John B · South Charleston, WVBuilt 1965 · S/N 18256600 N31MJN31mj LLC · Naples, FLBuilt 2020 · S/N 18283118 N31MRAllred Don J · Wellington, TXBuilt 1974 · S/N 18262907 N31PLGorum Michael Wren · Red Lodge, MTBuilt 1998 · S/N 18280095 N31SRIsaac Timothy S · Independence, ORBuilt 1962 · S/N 18051098 N31YBProgressive Air Inc · Janesville, WIBuilt 1979 · S/N 18266786 N3200SGreene James · Georgetown, TXBuilt 1964 · S/N 18255700 N3200UAnderson & Assoc Attorneys At Law Pc · Virginia Beach, VABuilt 1962 · S/N 18254600 N3200YCondo Gerardo B · Miami, FLBuilt 1962 · S/N 18254200 N3201DMelnick Victor D · Mount Bethel, PABuilt 1955 · S/N 31999 N3201SBoder Eric T · Knoxville, TNBuilt 1964 · S/N 18255701 N3202CJohnson Jeremiah · Fairbanks, AKS/N 18262345 N3203UKuykendall Kirk O · Lakeside, ORS/N 18254603 N3204DGriffith Sherman · Southlake, TXBuilt 1955 · S/N 32002 N3204UBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254604 N3205DWest James · Monroe, MIS/N 32003

Back to AD 84-10-01 R1