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.

N645FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843705 N645NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881146 N6461CTripacer Strategic Consulting LLC · Dover, DES/N 28-7816425 N6461RBetsy N6461r LLC · Novato, CABuilt 1966 · S/N 28-21648 N6461WOverstreet Aviation LLC · Sunray, TXBuilt 1964 · S/N 28-20534 N6462CA&J Aircraft Leasing Inc · Burlington, COBuilt 1978 · S/N 28-7816426 N6462JRentz Bradford C · Baxley, GABuilt 1968 · S/N 28-4885 N6462RGoodens Floorcovering Inc · Tallapoosa, GABuilt 1966 · S/N 28-21650 N6462WBauer Richard M · Greensboro, NCBuilt 1965 · S/N 28-21264 N6463JSorenson Mark A · Senoia, GABuilt 1968 · S/N 28-4886 N6464WTechnical Educational Services Inc T/A · Virginia Beach, VABuilt 1964 · S/N 28-20537 N6465JAardvark Aviation Inc · Greentown, INS/N 28-4889 N6466CConey Island Lunch LLC · Erie, PABuilt 1978 · S/N 28-7890374 N6466JHomesick Angel Aircraft Management · Grove, OKS/N 28-4890 N6467CSugden William H · Alexandria, MNBuilt 1978 · S/N 28-7890376 N6467JAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1968 · S/N 28-4892 N6467RKightlinger Kenny L Jr · Murfreesboro, TNS/N 28-21655 N6467WStichnoth Marvin L · Bourbonnais, ILBuilt 1964 · S/N 28-20540 N6468JTxfliers Aviation LLC · Corpus Christi, TXBuilt 1968 · S/N 28-4893 N6468RMargolis Brian M · Florence, MABuilt 1966 · S/N 28-21656 N6469JDouble Eagle Flyers LLC · Albuquerque, NMBuilt 1968 · S/N 28-4894 N6469RBaboul Anwar G · Carmel, INBuilt 1966 · S/N 28-21657 N6469WPivotal Aviation LLC · Spartanburg, SCBuilt 1964 · S/N 28-20542 N646FLTaylor William L · Fairfield, ILBuilt 1971 · S/N 28-7125554 N646FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843706 N646KWHely Aviation LLC · Columbus, INBuilt 2000 · S/N 32-46173 N646NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881143 N646SDBiton Liad · San Diego, CABuilt 1965 · S/N 32-294 N6470JSitlinger Angela R · Gratz, PABuilt 1968 · S/N 28-4896 N6470RAlterio Mark G · North Andover, MAS/N 28-21658 N6470WO'Kelly Albert · Caruthers, CABuilt 1964 · S/N 28-20543 N6471JMartinez Paul · Sonora, TXBuilt 1968 · S/N 28-4897 N6471RStraw Robert D · Farmington, MNBuilt 1966 · S/N 28-21659 N6472JFAA Flying Club Inc · Springfield, VABuilt 1968 · S/N 28-4898 N6472RWilson Richard J · Naknek, AKS/N 28-21660 N6472WSilaban Chandra · Independence, KYBuilt 1964 · S/N 28-20546 N6474JBenham Miriam · Elk Grove, CAS/N 28-4901 N6475CFulton Technology Corp · Caroleen, NCBuilt 1978 · S/N 28R-7803231 N6475JClark Clyde E · Naknek, AKBuilt 1968 · S/N 28-4902 N6475WJ K Merrill And Sons Inc · Pocatello, IDBuilt 1964 · S/N 28-20549 N6476RVlaz Richard J · Washington Twp, MIBuilt 1966 · S/N 28-21665 N6477JSweat Jeremy A · Morrill, KSS/N 28-4904 N6477WWashington Samuel L · Cleveland, MSBuilt 1965 · S/N 28-20551 N6478JPart Guy LLC · Berlin, NJS/N 28-4905 N6478WLamar Edward Blake Jr · Rch Palos Vrd, CABuilt 1964 · S/N 28-20552 N6479JBabula Ronald Lee Jr · Drums, PABuilt 1968 · S/N 28-4906 N6479RGromada Kristian Paul · Eagle River, AKBuilt 1966 · S/N 28-21669 N6479WManagement Ranch LLC · Sheridan, WYBuilt 1964 · S/N 28-20553 N647BMaxiao Aviation Corp · Milpitas, CABuilt 1979 · S/N 32-7940040 N647CABilli The Flying Cat LLC · Atlanta, GABuilt 1978 · S/N 28-7890312

Back to AD 87-08-08 R3