Skip to content

Registered aircraft · 81,720

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:81-18-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:81-18-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:81-18-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:81-18-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:81-18-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:81-18-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.

N1972BPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1972 · S/N 34-7250173 N1972EMartin George C · Charleston, WVS/N 17271106 N1972GCapone Eugene L DBA · Frisco, TXBuilt 1972 · S/N AA5-0157 N1972KBachtac Aviation LLC · Clarksville, TXBuilt 1977 · S/N 32R-7780030 N1972PKitcen Thomas M · Indiana, PABuilt 2001 · S/N 01-99 N1972QFlying Associates Inc · Hudson, WIBuilt 1973 · S/N 177RG0372 N1972WCaruso Timothy Ernest · Gainesville, VABuilt 1962 · S/N 2332 N19730Terrasi John D · Pittsfield, PABuilt 1972 · S/N 17260705 N19731Valiair Lc Trustee · Casper, WYBuilt 1972 · S/N 17260706 N19733Jones Darrell W · Kennett, MOBuilt 1972 · S/N 17260707 N19736Friendship Mark · Topanga, CABuilt 1972 · S/N 17260710 N19739Breen Peter Herschel · Irvine, CABuilt 1972 · S/N 17260713 N1973FRuiz Naile C · Davie, FLBuilt 1979 · S/N 17273061 N1973GBarrette Michael Patrick · Saginaw, MIBuilt 1973 · S/N 28-7305358 N1973HAllen Quandt Inc · Grand Island, NES/N 28-7716073 N1973VMurphy Peter · Streamwood, ILBuilt 1974 · S/N 17263809 N19740Hendrickson David O · Crab Orchard, KYBuilt 1972 · S/N 17260714 N19742Four Hearts Farm LLC · Sunbury, OHBuilt 1972 · S/N 17260715 N19746Kingdom Aviation Group LLC · Thomasville, GABuilt 1972 · S/N 17260717 N19747Chase Tyler D · Ephrata, WABuilt 1972 · S/N 17260718 N19748Scaringe William A Jr · Culver City, CABuilt 1976 · S/N 17702588 N19749Curry Kim M · Griggsville, ILBuilt 1972 · S/N 17260720 N1974FBusler Bradley R · Nacogdoches, TXBuilt 1979 · S/N 17273062 N1974JTexarkana Flying Club Inc · Texarkana, TXBuilt 1973 · S/N 17262513 N1974PWarren Josiah E · Sterling, AKBuilt 1955 · S/N 18-4207 N1974QMag Air LLC · West Miami, FLBuilt 1973 · S/N 177RG0374 N1974WObannon Michael Verlin · Apple Valley, CAS/N MB-633 N1974YHemperly Jeffery L · Massillon, OHBuilt 1974 · S/N AA1B-0444 N19751Alaska Farm Tours LLC · Palmer, AKS/N 17260721 N19752Platt Aaron · Heppner, ORBuilt 1972 · S/N 17260722 N19753Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 17260723 N19757Kalamir Richard · Valparaiso, INBuilt 1972 · S/N 17260726 N19758Walsh Robert F · Tucson, AZBuilt 1976 · S/N 17702589 N1975FWard Gary T · Cincinnati, OHBuilt 1979 · S/N 17273063 N1975LClarke Ted · La Luz, NMBuilt 1965 · S/N 673 N1975ULawler Thomas O · Lava Hot Springs, IDBuilt 2023 · S/N 3418 N19760Aero Assn Of California Institute Of Technology · Pasadena, CABuilt 1972 · S/N 17260729 N19762Boyertown Flying Club Inc · Devon, PABuilt 1976 · S/N 17702590 N19763N19762 LLC · Tigard, ORBuilt 1976 · S/N 17702591 N19766Owens Wilbur · Rch Palos Vrd, CAS/N 17260734 N19768Glacier Flight Training LLC · Whitefish, MTS/N 17260736 N1976BEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 0637 N1976FRaritan Valley Flying School · Princeton, NJBuilt 1979 · S/N 17273064 N1976LLuke Ivan T · Hope Valley, RIBuilt 2021 · S/N 74044 N1976TSickels Charles Joseph · San Diego, CAS/N AA5B0323 N19771Tetoff Logan P · Bethel, AKBuilt 1972 · S/N 17260739 N19773Burtch Timothy J · Washington, DCBuilt 1972 · S/N 17260740 N19775Skyhawk Leasing LLC · Odenville, ALBuilt 1972 · S/N 17260742 N19777Rtd Aviation LLC · Hillsborough, NJBuilt 1972 · S/N 17260744 N19778Marx John C · Edgewood, WABuilt 1972 · S/N 17260745

Back to AD 81-18-04 R2