Skip to content

Registered aircraft · 22,413

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

N411BCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 2843339 N411BSMa Aviation Group LLC · Farmingdale, NYBuilt 2004 · S/N 2843598 N411FLSmith J Lewis IV · Land O Lakes, FLS/N 28-7125188 N411NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010005 N411RTAlthouse Jerry L · Granbury, TXBuilt 1972 · S/N 28R-7235301 N411SFTechniflyte Services LLC · Southbury, CTBuilt 1977 · S/N 32R-7780536 N411WPN411wp LLC · Mount Vernon, OHBuilt 1968 · S/N 28-4826 N41206Dalforno Ronald L · Los Banos, CABuilt 1974 · S/N 28-7415137 N41207Readio Gary H · Cumberland, MEBuilt 1974 · S/N 28R-7435154 N41208Scott Kevin L · Kissimmee, FLBuilt 1974 · S/N 32-7440076 N41209Remy Investments LLC · Fairfax, VABuilt 1974 · S/N 28-7405071 N4120FBcs Air Inc · Oakhurst, CABuilt 1976 · S/N 28-7790005 N4120KJansar Aviation LLC · Farmington Hills, MIBuilt 1999 · S/N 2843225 N4120SBukstein Michael J · Hannibal, MOBuilt 1998 · S/N 3257045 N4120WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1967 · S/N 32-40184 N41210Fisher Jordan L · Bennington, NEBuilt 1974 · S/N 32-7440061 N41214Kamler Ron · Santa Rosa, CABuilt 1974 · S/N 28-7425207 N41216Pontiac Flying LLC · Pontiac, ILBuilt 1974 · S/N 28-7415138 N41217Kraut William A · Tiffin, OHBuilt 1974 · S/N 28-7415387 N4121AAirjohn LLC · Cheyenne, WYBuilt 1994 · S/N 2811047 N4121JForster Simon J · Cedar Park, TXBuilt 1966 · S/N 28-22439 N4121RTaylor John W · Slatington, PABuilt 1998 · S/N 2843134 N4121TChandler Air Service Inc · Chandler, AZBuilt 1996 · S/N 2842017 N41223Chen Melissa Y Fan · Montverde, FLS/N 28-7425208 N41229Whitewings Inc · Lewis Center, OHBuilt 1974 · S/N 28-7405084 N4122DCloud Chaser Aviation LLC · Chesnee, SCBuilt 1998 · S/N 2843130 N4122JCollum Aviation LLC · Milton, FLBuilt 1966 · S/N 28-22440 N4122KWargo Michael S · Colorado Springs, COBuilt 1998 · S/N 3246106 N4122RLowenslow LLC · Hailey, IDBuilt 1997 · S/N 3257010 N4122WGo West Aviation LLC · Gillette, WYBuilt 1967 · S/N 32-40186 N41230Heller Ross S · Gig Harbor, WABuilt 1974 · S/N 28R-7435158 N4123JHebrank Kenneth A · Greensburg, PABuilt 1966 · S/N 28-22441 N4123UCavu Air Holdings Inc · Dover, DES/N 3246116 N4123WSchaal Donald P · Wauconda, ILS/N 32-40187 N41241N84dt LLC · Missoula, MTS/N 28-7415144 N41243Collette Cameron Hayes · Tuscaloosa, ALBuilt 1974 · S/N 28-7415146 N4124JRiggin Flight Service Inc · Madison, SDBuilt 1966 · S/N 28-22443 N4124MN4124m LLC · Richfield, OHBuilt 1999 · S/N 2843214 N4124N2c Air LLC · Edmond, OKBuilt 1998 · S/N 2843146 N4124VFlyry Aviation LLC · Mahwah, NJBuilt 1998 · S/N 2843155 N4124ZAustin Kyle · Havre, MTBuilt 1998 · S/N 2843187 N41259Pan Am Flight Services - St Joseph LLC · Saint Joseph, MOBuilt 1998 · S/N 2843138 N4125DSrq Framing LLC · Sarasota, FLS/N 3246103 N4125JYero Miguel A III · Santa Ana, CABuilt 1966 · S/N 28-22444 N4125KFiji Air LLC · Atlanta, GABuilt 1998 · S/N 3246114 N4125VMyhrstad Thor · Aptos, CABuilt 1998 · S/N 2843165 N41262Sholley Michael R · Long Beach, CABuilt 1974 · S/N 28-7415148 N41264Cedar County Flying Club Inc · Tipton, IABuilt 1974 · S/N 28-7415149 N41265Sunrise Aviation Y1n LLC · Albert Lea, MNBuilt 1974 · S/N 28-7405087 N41267Faulkner Terry · Dixon, CAS/N 28-7415151

Back to AD 87-08-08 R3