Skip to content

Registered aircraft · 17,027

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:72-03-03-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:72-03-03-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:72-03-03-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:72-03-03-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:72-03-03-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:72-03-03-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.

N211WTBetelgeuse Aviation LLC · Houston, TXBuilt 1978 · S/N 177RG1321 N2120FWare Brandie W · Nikiski, AKS/N U206-0320 N2120ROda Mark E · Angola, INBuilt 1964 · S/N 18255320 N2121LDl Contractors Inc · Rexburg, IDBuilt 1964 · S/N 18255370 N2121QSchardt James A · Garden Valley, CABuilt 1974 · S/N 177RG0521 N2121RDengler Phillip L · Bordentown, NJBuilt 1964 · S/N 18255321 N2123QMellor James F · Spanish Fork, UTS/N 177RG0523 N2123RHowell William J · Incline Village, NVS/N 18255323 N2124QBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 177RG0524 N2124RKokjer Kenneth J · Fairbanks, AKBuilt 1964 · S/N 18255324 N2125QRizzuto Nunzio Stephen · Decatur, ALBuilt 1974 · S/N 177RG0525 N2125RHogue William B Jr · Simi Valley, CABuilt 1964 · S/N 18255325 N2126QDurable Industrial Finishing Co Inc · Tucker, GABuilt 1974 · S/N 177RG0526 N2127FBrice Adam R · Camas, WAFirst renewal noticeBuilt 1964 · S/N U206-0327 N2128RCreasey Daniel L · Arnold, MOBuilt 1964 · S/N 18255328 N2129DLoadholtz Heath T · Watford City, NDBuilt 1965 · S/N 18256143 N2129FStewart Madison F Co Persona Representative · Broken Arrow, OKBuilt 1965 · S/N U206-0329 N2129QEarnshaw Larry L · Erie, COBuilt 1974 · S/N 177RG0529 N212CCChristenson Charles F · Auburn, WABuilt 1966 · S/N 18257852 N212KTLanier Howard W · Willis, TXS/N P206-0349 N212TMSchuldt Scott A · North Little Rock, ARBuilt 1968 · S/N 17701004 N2131FHerschberger Glen M · Willow, AKBuilt 1964 · S/N U206-0331 N2131QImhoff Donald W · Baton Rouge, LABuilt 1974 · S/N 177RG0531 N2131RCapriccio Leasing LLC · Tigard, ORBuilt 1964 · S/N 182-55331 N2132FHitchcock Wayne · Shelbyville, TNBuilt 1964 · S/N U206-0332 N2132QHawk Aviation Inc · Chesapeake Beach, MDBuilt 1974 · S/N 177RG0532 N2132RSifsof Victor G DBA · Anchorage, AKBuilt 1964 · S/N 18255332 N2133RLewis Christopher S · Hancock, MIBuilt 1964 · S/N 18255333 N2134QLuft Aviation Inc · Wilmington, DEBuilt 1974 · S/N 177RG0534 N2135GCrawford Mark E · Pleasant Ridge, MIBuilt 1970 · S/N 15071682 N2136QStoneman Excav Co Inc · Ashland, VABuilt 1974 · S/N 177RG0536 N2136RGibbens John L Trustee · Rock Springs, WYBuilt 1964 · S/N 18255336 N2137QInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0537 N2137RFreefall Express Inc · Gardiner, NYBuilt 1964 · S/N 18255337 N2139FCrow Brian M · Oakesdale, WABuilt 1965 · S/N U206-0339 N2139RShaw Gregory A · West Richland, WABuilt 1964 · S/N 18255339 N213MBNational Tax Relief Inc · Riverside, CAS/N 17702282 N2140QAtlantic Beach Flyers LLC · Atlantic Beach, FLBuilt 1974 · S/N 177RG0540 N2141FHill Henry M · Sleetmute, AKBuilt 1965 · S/N U206-0341 N2141QNeuman Allen D · Sanger, TXS/N 177RG0541 N2142QLichtenberg Jeffrey L · Brookfield, MOBuilt 1974 · S/N 177RG0542 N2144RButterfield Stephen · Nampa, IDS/N 18255344 N2145QErnstes William L · Greensburg, INBuilt 1974 · S/N 177RG0545 N2146QMcdonald Anthony Robert · Brookside, UTBuilt 1974 · S/N 177RG0546 N2148QMorten Jesse L · Larimore, NDBuilt 1974 · S/N 177RG0548 N2149QRegistered aircraftBuilt 1974 · S/N 177RG0549 N214ESIsaacs Mark S · Terre Haute, INBuilt 1961 · S/N 18253673 N214RDAardvark Aircraft LLC · Kalamazoo, MIBuilt 1964 · S/N 18255546 N214WKOutbound Group LLC · St Petersburg, FLBuilt 1969 · S/N 18260041 N2151RMclelland Ronald James · Taylorville, NCBuilt 1964 · S/N 18255351

Back to AD 72-03-03 R3