Skip to content

Registered aircraft · 20,481

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.

N759DSCampbell House & Company LLC · Monroe, LABuilt 1977 · S/N 18265916 N759DTTgaap LLC · Broken Bow, NEBuilt 1977 · S/N 18265917 N759DUWeeks Steven M · Pensacola, FLBuilt 1977 · S/N 18265918 N759EAHaffner Ron · Comfort, TXBuilt 1977 · S/N 18265924 N759EGCypress Enterprise LLC · Tifton, GABuilt 1977 · S/N 18265930 N759EKNewcomb Barry K · Woodbury, NJBuilt 1977 · S/N 18265933 N759ETPollock Craig · Walnut Creek, CABuilt 1977 · S/N 18265941 N759EUNovak James A Jr · Dryden, MIS/N 18265942 N759EXBurnham James A · Macomb, ILBuilt 1977 · S/N 18265945 N759EYClifford Gary G · Titusville, FLBuilt 1977 · S/N 18265946 N759FEAdams William T · Byron, CABuilt 1977 · S/N 18265952 N759FJAir Bear Inc · Williston, VTBuilt 1977 · S/N 18265956 N759FUWinkeler Ralph B · Newbury Park, CABuilt 1977 · S/N 18265966 N759FWWendell Terry D II · Owens Cross Roads, ALBuilt 1977 · S/N 18265968 N759FZCullinan Robert B · Rch Palos Vrd, CAS/N 18265971 N759GBFly High Country LLC · Jackson, WYBuilt 1978 · S/N 18265973 N759GDThin Air Inc · Hays, KSBuilt 1977 · S/N 18265975 N759GEVandyke Daniel · Grand Rapids, MIBuilt 1977 · S/N 18265976 N759GFMountain Flyers Inc · Hendersonville, NCBuilt 1977 · S/N 18265977 N759GGParrish William E · Peyton, COBuilt 1977 · S/N 18265978 N759GLAir Capital Aviators Club · Wichita, KSBuilt 1977 · S/N 18265982 N759GMDalmau Cristoffer R · Marietta, GABuilt 1977 · S/N 18265983 N759GPRobinson Brad A · Port Orange, FLBuilt 1977 · S/N 18265985 N759GQMckeever Aviation LLC · Benton, LABuilt 1977 · S/N 18265986 N759GVTeague Lake Diversified LLC · Wilmington, DEBuilt 1977 · S/N 18265991 N759GWHill Ana · Monument, COBuilt 1977 · S/N 18265992 N759GZZadel Robert M · Chandler, AZBuilt 1977 · S/N 18265995 N759HALimited Aviation LLC · Cheshire, CTBuilt 1977 · S/N 18265996 N759HBLesser Timothy J · Sherwood, ORBuilt 1977 · S/N 18265997 N759HCMojo Chicken Aviation LLC · Mount Pleasant, SCS/N 18265998 N759HDMayers Nathan A · Calhoun, GABuilt 1977 · S/N 18265999 N759HEDennis Steven T · Hayden Lake, IDBuilt 1977 · S/N 18266000 N759HGDiamond Valley Hay Company Inc · Eureka, NVBuilt 1977 · S/N 18266002 N759HJD&M Flyer LLC · Petaluma, CABuilt 1977 · S/N 18266004 N759HLRuddle Thomas S · Columbia, TNBuilt 1977 · S/N 18266006 N759HMT&T Cattle LLC · Clayton, NMBuilt 1977 · S/N 18266007 N759HPWinchester Skylane Flyers LLC · Winchester, VABuilt 1977 · S/N 18266009 N759HQDellinger Hughes R Jr · Gloucester, VABuilt 1977 · S/N 18266010 N759HRMountain Vista Aviation LLC · Los Alamos, NMBuilt 1977 · S/N 18266011 N759HSUlrich Michael J · Lancaster, PABuilt 1977 · S/N 18266012 N759HTKflg LLC · Flagstaff, AZBuilt 1977 · S/N 18266013 N759HXLabell Aviation LLC · Spring Hill, FLBuilt 1977 · S/N 18266017 N759HYIrwin Dennis R · Darby, MTBuilt 1977 · S/N 18266018 N759HZCade Michael · Sonoita, AZBuilt 1977 · S/N 18266019 N759JASturgeon James L · Spring Hill, FLBuilt 1977 · S/N 18266020 N759JBMpms Inc · Munford, TNBuilt 1979 · S/N 18266968 N759JDEnne · Memphis, TNBuilt 1977 · S/N 18266023 N759JFCrc Aviation LLC · Woodville, MSS/N 18266025 N759JGMgvw Capital Holdings LLC · Saint Petersburg, FLS/N 18266026 N759JH3d Capture LLC · Lumberton, TXBuilt 1977 · S/N 18266027

Back to AD 84-10-01 R1