Skip to content

Registered aircraft · 1,686

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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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.

N717DKRegistration Pending · North Las Vegas, NVRegistration pendingBuilt 1973 · S/N 21060113 N718APAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1977 · S/N 21061857 N71924Keystone Aerial Surveys Inc · Philadelphia, PABuilt 1968 · S/N U206-1226 N71WTBear Cat Air LLC · Gun Barrel City, TXS/N 21061505 N721Department Of The Interior · Boise, IDBuilt 1981 · S/N U20606256 N7213NSouth Aero LLC · Albuquerque, NMBuilt 1979 · S/N 21063207 N72160Mccauley Thomas I · Puyallup, WAS/N U206-1303 N72194Skydive Ky LLC · Cecilia, KYBuilt 1969 · S/N U206-1315 N72288Roberts Matthew R · Idaho Falls, IDFirst renewal noticeBuilt 1969 · S/N U206-1353 N722ELBristow Bryan M · Albany, ORBuilt 1981 · S/N 21064332 N722PDW O Zangger And Son Inc · North Loup, NEBuilt 1976 · S/N 21059833 N722RRAncira Autos LLC · San Antonio, TXBuilt 1979 · S/N 21063651 N7250NSimon Jevon · Buckley, WABuilt 1979 · S/N 21063213 N7257NPeterson Winston Roy II · Arbuckle, CABuilt 1976 · S/N U20603588 N726HSSpmhrt 206 LLC · East Bernard, TXS/N U20606947 N727DRRoss Trucking LLC · Goldendale, WAS/N U206-0556 N727FACorporate Services LLC · Baton Rouge, LAS/N 21059414 N727WSRobey Sean C · Camden, NCFirst renewal noticeBuilt 1978 · S/N 21063140 N7303NJordan James D · Paradise, TXBuilt 1979 · S/N 21063218 N7305URyan Air Inc · Anchorage, AKBuilt 1977 · S/N 20700392 N7329NRegent Trust Corp Trustee · Wichita, KSS/N 21063220 N732ADDavis Billy E · Castlewood, SDBuilt 1976 · S/N 21061355 N732AQGold Star Air · Portland, MEBuilt 1976 · S/N 21061366 N732BASparks Steve · Hamilton, OHBuilt 1976 · S/N 21061376 N732BBBishop Thomas W · Decatur, TXBuilt 1976 · S/N 21061377 N732BKJones Mark A · Johnson City, TXBuilt 1976 · S/N 21061385 N732CBAire Flight Systems Inc · Midwest City, OKBuilt 1976 · S/N 21061400 N732CRGlobal Energy Werks LLC · Ely, MNBuilt 1976 · S/N 21061414 N732CXEvans Terry W · Corning, IABuilt 1976 · S/N 21061420 N732DKMckay Donald E · White City, ORBuilt 1976 · S/N 21061432 N732DMFlying Knights LLC · Farmington, NMS/N 21061434 N732DQAcme Do It Yourself Tornado Kits LLC · Draper, UTBuilt 1976 · S/N 21061437 N732DWKowalczyk Ryan · Boise, IDBuilt 1976 · S/N 21061443 N732ECPompa Oliver · Tucson, AZBuilt 1976 · S/N 21061448 N732GK3jc LLC · Phoenix, AZBuilt 1976 · S/N 21061500 N732HDMgp Investments LLC · Woods Cross, UTBuilt 1976 · S/N 21061518 N732HKAnderson Milton M · Twin Bridges, MTS/N 21061524 N732HRBowdle Ricke H · San Dimas, CABuilt 1978 · S/N U20604680 N732JFSpeed Of Light Aerospace LLC · Lompoc, CABuilt 1976 · S/N 21061543 N732JJCj Air LLC · Escondido, CABuilt 1976 · S/N 21061546 N732JS732js Partners Ltd · Batavia, ILBuilt 1976 · S/N 21061554 N732JWSunniland Ranch Airport LLC · Okeechobee, FLS/N 21061558 N732KBTadco Equipment Inc · Laveen, AZBuilt 1976 · S/N 21061563 N732KCKing Daddy Aviation LLC · Madison, MSBuilt 1976 · S/N 21061564 N732KEMcintosh Ian K · Floydada, TXS/N 21061566 N732KPB&M Aviation LLC · Montgomery, TXBuilt 1976 · S/N 21061575 N732KQPerea Rudolph A · Dayton, NVBuilt 1976 · S/N 21061576 N732LPAgile Innovations LLC · Kalispell, MTS/N 21061599 N732LTPerfection Training Kennels LLC · Gallatin, MOS/N 21061603 N732MYGrand River Construction Co · Glenwood Springs, COS/N 21061631

Back to AD 71-09-07 R1