Skip to content

Registered aircraft · 54,015

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-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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:87-20-03-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.

N759NFN759nf LLC · Wilmington, DEBuilt 1977 · S/N 18266121 N759NGWackman Ranch · Elk Grove, CABuilt 1977 · S/N 18266122 N759NJBlair Aircraft No 1 LLC · Salt Lake City, UTBuilt 1977 · S/N 18266124 N759NLGolden Thaddeus · Myrtle Beach, SCBuilt 1977 · S/N 18266126 N759NRNugent Patrick L · Keller, TXBuilt 1977 · S/N 18266131 N759NSAnsorge Inc · Elk Grove, CABuilt 1978 · S/N 18266132 N759NZMassa John · Fayetteville, GABuilt 1977 · S/N 18266139 N759PCFrihed LLC · West Yellowstone, MTBuilt 1977 · S/N 18266142 N759PDEmd Enterprises LLC · Lafayette, LAFirst renewal noticeBuilt 1977 · S/N 18266143 N759PERay James · Twin Falls, IDBuilt 1977 · S/N 18266144 N759PHKriss Richard Co-Trustee · Poulsbo, WABuilt 1977 · S/N 18266147 N759PJBoyaire Inc · Harvest, ALBuilt 1977 · S/N 18266148 N759PKIberlin Ranch · Gillette, WYBuilt 1977 · S/N 18266149 N759PLLewis Robert B · Lexington, VABuilt 1977 · S/N 18266150 N759PMRocereta Michael D · Eagle River, AKBuilt 1977 · S/N 18266151 N759PNBrown Richard D · Shelbyville, ILBuilt 1977 · S/N 18266152 N759PSKessler Steven F · Whitewater, WIBuilt 1977 · S/N 18266156 N759PTSparkman Wings LLC · Greenville, SCBuilt 1977 · S/N 18266157 N759QDTonya Byrd Insurance Agency Inc · Turbeville, SCBuilt 1977 · S/N 18266167 N759QHKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1977 · S/N 18266171 N759QLDanger Zone Aviation LLC · Mound, MNBuilt 1977 · S/N 18266174 N759QNJordan Russell L · Grand Junction, COBuilt 1977 · S/N 18266176 N759QTSalkantay Aviation LLC · Prosper, TXBuilt 1977 · S/N 18266181 N759QYBdr Aviation LLC · Dover, DEBuilt 1977 · S/N 18266186 N759QZRollins Thomas M · Salt Lake City, UTBuilt 1977 · S/N 18266187 N759RAPrx Philip G · Fairbanks, AKBuilt 1977 · S/N 18266188 N759RDWilliams Kenneth R · Bakersfield, CABuilt 1977 · S/N 18266191 N759RERissel Phillip R · Hillsboro, ORBuilt 1977 · S/N 18266192 N759RFWiley Jason L · Eau Claire, WIBuilt 1977 · S/N 18266193 N759RGWilkie Bruce · Georgtown, TXBuilt 1977 · S/N 18266194 N759RMK&G Transit LLC · Fort Mc Coy, FLBuilt 1977 · S/N 18266199 N759RNAshmead Thomas G · Somerset, CABuilt 1977 · S/N 18266200 N759RPSayum LLC · Gonzales, CABuilt 1978 · S/N 18266155 N759RRN759rr LLC · Franklin, TNBuilt 1977 · S/N 18266203 N759RTMazur John · Port Orange, FLBuilt 1977 · S/N 18266205 N759RVOklahoma Airmen Flying Club Inc · Jenks, OKBuilt 1977 · S/N 18266207 N759RWLeone Frank T · Elmwood, NEBuilt 1977 · S/N 18266208 N759RZWelch Ronald R · Moses Lake, WABuilt 1977 · S/N 18266211 N759STraining Planes LLC · Tampa, FLBuilt 1974 · S/N 17264166 N759SGSalty Dog Aviation LLC · De Soto, MOBuilt 1977 · S/N 18266218 N759SKMolster Clark · Newbury Park, CABuilt 1977 · S/N 18266221 N759SLSirmon James A · Daphne, ALBuilt 1978 · S/N 18266222 N759SPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N 18266225 N759SRMazz Airplane 1 LLC · Elbert, COBuilt 1978 · S/N 18266227 N759TAKay Betty T · Brigham City, UTBuilt 1978 · S/N 18266236 N759TDHollingshead Michael · Murfreesboro, TNS/N 18266239 N759TFGardner Robert · Bellevue, IDBuilt 1978 · S/N 18266241 N759TGTwgr LLC · Amarillo, TXBuilt 1978 · S/N 18266242 N759TJFlying Anchor Aviation LLC · Seattle, WABuilt 1978 · S/N 18266244 N759TMCastro Joseph · Boston, MABuilt 1978 · S/N 18266247

Back to AD 87-20-03 R2