Skip to content

Registered aircraft · 4,469

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-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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.

N65YLippman Thomas N Trustee · Brisbane, CABuilt 1977 · S/N D-10080 N660R660 Romeo LLC · Tulsa, OKBuilt 1968 · S/N D-8826 N660VSky Guy LLC · Frankenmuth, MIBuilt 1960 · S/N D-6415 N661BWTailwinds Services And Commodities Inc · Brandon, MSBuilt 1961 · S/N D-6661 N661SBLusby Robert G Jr · Knoxville, TNBuilt 1966 · S/N D-8233 N6621SOverbey Michael C · Watkinsville, GABuilt 1976 · S/N D-9845 N6625RBeech South LLC · Kalispell, MTBuilt 1982 · S/N D-10395 N662KWDavis Daniel · Bloomington, MNS/N D-6389 N66409Dans Flying Service Inc · Crookston, MNBuilt 1979 · S/N D-10261 N6640LHyder Steven Richard · Albuquerque, NMBuilt 1979 · S/N D-10257 N6641RWightman William Adams Jr · Yukon, OKBuilt 1979 · S/N D-10230 N66421Gleim Garrett William · Gainesville, FLBuilt 1979 · S/N D-10267 N6643QSky High Solutions Inc · Miami, FLBuilt 1979 · S/N D-10265 N6646SHolub James T · Wellington, FLS/N D-10252 N6648NMark & David LLC · Coldwater, MSBuilt 1979 · S/N D-10250 N6649SRay James William · Albert, NMBuilt 1976 · S/N D-9847 N664DMStar Air Group LLC · Anchorage, AKBuilt 1968 · S/N D-8721 N664EDrury Herbert R Jr · Maynard, MABuilt 1951 · S/N D-2934 N664HWWilliamson Kemal · O Fallon, ILBuilt 1979 · S/N D-10260 N664TBechtol Andrew M · Long Beach, CABuilt 1972 · S/N D-9374 N6652DRafter B Cattle Company LLC · Gordonville, TXBuilt 1979 · S/N D-10254 N6653DWilliams Lee V · Dallas, TXS/N D-10256 N6653RRegistered aircraftBuilt 1979 · S/N D-10259 N6653VWalker Ray A · Sanger, TXBuilt 1979 · S/N D-10253 N6654RLow Mach Aero LLC · Hays, KSBuilt 1979 · S/N D-10273 N6656RHarris Walter D · Chatham, NJBuilt 1979 · S/N D-10275 N6658DThietten Gary L Trustee · Washington, UTBuilt 1979 · S/N D-10312 N6658KEdelman Freddie L · Manlius, NYBuilt 1979 · S/N D-10278 N6659LControl Data Inc · Indianapolis, INBuilt 1979 · S/N D-10279 N6662HIrwin Dennis · San Diego, CABuilt 1979 · S/N D-10290 N6662TSeipp Edwin A III · Portola Valley, CABuilt 1979 · S/N D-10284 N66648Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N D10289 N6665ZDunkley Music Inc · Meridian, IDBuilt 1979 · S/N D-10291 N666MSSandy Bayou Planting Co · Osceola, ARBuilt 1969 · S/N D-9004 N666WBertie William D · Independence, KSBuilt 1952 · S/N D-3170 N666WFFehlhaber Wolfgang M · Port Orange, FLBuilt 1976 · S/N D-9885 N666ZRobertson Jared Y · Pass Christian, MSBuilt 1960 · S/N D-6317 N6670JMccracken Scott D · Maysville, OKBuilt 1979 · S/N D-10295 N667DWombles Earnest · Knoxville, TNBuilt 1952 · S/N D-2938 N66818Schultz Gregory L · Greenbush, MNS/N D-10310 N6683DRegional Consultants LLC · Wilmington, DEBuilt 1979 · S/N D-10311 N6685RGlobal Distillation Services LLC · Reno, NVBuilt 1979 · S/N D-10314 N66876Mcmarlin Richard C · Santa Fe, NMBuilt 1979 · S/N D-10316 N6688EHill Daniel DBA · Grove, OKBuilt 1979 · S/N D-10319 N6688JQuesnel Robert Todd · Tomball, TXBuilt 1979 · S/N D-10299 N6688UHotel Lima LLC · Oro Valley, AZBuilt 1980 · S/N D-10320 N6689JAce Technical Services LLC · Hernando, MSBuilt 1979 · S/N D-10321 N668ZSDrumwright Gerald L · Ormond Beach, FLBuilt 1979 · S/N D-10258 N66907Flynn Curtis J · Granbury, TXBuilt 1979 · S/N D-10322 N66916Technet Aviation LLC · Charlotte, MIS/N D-10327

Back to AD 94-20-04 R2