Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N8506QBell Robert C · Colby, KSS/N U20603363 N8506TM & C Aviation LLC · Corinth, TXBuilt 1959 · S/N 52406 N85074Patriot Pole Aviation LLC · Missouri Valley, IABuilt 1975 · S/N 18263614 N8508S8508s LLC · Yerington, NVBuilt 1965 · S/N 18256608 N8508TLily Gold LLC · Wilmington, DEBuilt 1959 · S/N 52408 N850WBMorris John A · Phoenix, AZBuilt 1968 · S/N 185-1350 N8510SBarton Andrew · Morehead City, NCBuilt 1965 · S/N 18256610 N8511TAcute Holdings LLC · Jenks, OKBuilt 1960 · S/N 52411 N8512SDoss Jacob · Casco, MIBuilt 1965 · S/N 18256612 N8512TRegistration Pending · Odessa, TXRegistration pendingBuilt 1959 · S/N 52412 N8513SBeach Thomas C III · Salado, TXBuilt 1965 · S/N 18256613 N8514QAvila Robert A · Lawrence, MABuilt 1976 · S/N U20603371 N8514TCombee Ann W · Winter Haven, FLRegistration expired, pending cancellationBuilt 1959 · S/N 52414 N8515SHawkins Kenneth Roger · Globe, AZBuilt 1965 · S/N 18256615 N8515TGraham Richard · Farmingdale, NYBuilt 1959 · S/N 52415 N8516MSealane LLC · Burlingame, CABuilt 1970 · S/N 18260446 N8516SReik Thomas Donaldson Jr · New Port Richey, FLBuilt 1965 · S/N 18256616 N8517STardif Jean Y · Moorpark, CABuilt 1965 · S/N 18256617 N8517TWahl John Jr · Yelm, WABuilt 1959 · S/N 52417 N8519SCinden LLC · Nashua, NHBuilt 1965 · S/N 18256619 N851CAT&B Aero LLC · Jacksonville, FLS/N 18267851 N851DABhh Leasing #4 LLC · Pensacola, FLBuilt 1970 · S/N 32600 N851MDKiko Peter R · Dalton, OHBuilt 1956 · S/N 33514 N8520SClark Joseph D · Kilgore, TXBuilt 1965 · S/N 18256620 N8522TWicklander Richard O · Spanaway, WABuilt 1959 · S/N 52422 N8523QLifetime Adventures LLC · Bellevue, MIBuilt 1976 · S/N U20603379 N8523THorning Jason R · Seffner, FLBuilt 1959 · S/N 52423 N8524SLoyer Victor D · Palmer, AKBuilt 1965 · S/N 18256624 N8524TMurlin David · Hemet, CABuilt 1959 · S/N 52424 N8525TSmith Randall M · Escondido, CABuilt 1959 · S/N 52425 N8526QKenworthy Winston C · Odessa, TXBuilt 1976 · S/N U20603382 N8526TJoachim Barry L · Lubbock, TXBuilt 1960 · S/N 52426 N8528SLucas Robert I · Jackson, WYS/N 18256628 N8528TLonni Rasmussen · Lehi, UTBuilt 1959 · S/N 52428 N8529SWollan David · Shelby, MTBuilt 1965 · S/N 18256629 N852LRSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608313 N8530TZakis Stephen · Hillsdale, WYBuilt 1959 · S/N 52430 N8531THarms Reuben S · Jackson, GABuilt 1959 · S/N 52431 N8533TAirmotive Service LLC · Brigham City, UTBuilt 1960 · S/N 52433 N8534SBorreson Anthony · Mariposa, CABuilt 1965 · S/N 18256634 N8534TCoonrods Garage LLC · Dodd City, TXBuilt 1959 · S/N 52434 N8536SClear Skies Aviation LLC · Reserve, MTBuilt 1965 · S/N 18256636 N8539SFarmair Inc · Hughesville, PABuilt 1965 · S/N 18256639 N8539TCorbitt James Todd · Irvine, CABuilt 1959 · S/N 52439 N8539ZRiggs Randy G · Creede, COBuilt 1958 · S/N 51452 N853CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281853 N853HLJohnson Jeffrey A · Fort Collins, COBuilt 1985 · S/N 18268446 N853PMMoody Bible Institute Of Chicago · Spokane, WAS/N 185-0459 N8540TLoge Pilot LLC · Walker, MNS/N 52440 N8541LGreat Basin Aviation LLC · Eagle River, AKS/N 185-0118

Back to AD 84-10-01 R1