Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N6872ACoats Alexander · Murrieta, CAS/N 28972 N6874AGillum Thomas W III · Davenport, IABuilt 1956 · S/N 28974 N6876HSt Charles County Flying Club LLC · Portage Des Sioux, MOBuilt 1975 · S/N 17265622 N6877ASchenck Alan E · Clarinda, IABuilt 1956 · S/N 28977 N6877HKoenig Ned · New Bremen, OHBuilt 1975 · S/N 17265623 N6877XSwick Gerald K · Murfreesboro, TNBuilt 1960 · S/N 17247777 N6878XLinkinhoker Craig W · Carpentersville, ILBuilt 1960 · S/N 17247778 N6879XRegistration Pending · Farr West, UTRegistration pendingBuilt 1960 · S/N 17247779 N687AZZublin John A III · Murrieta, CABuilt 1968 · S/N 17256592 N687BASvetfur Aviation LLC · Camden, SCBuilt 2015 · S/N 172S11581 N687SPBmg Aviation Inc · Bloomington, INBuilt 1999 · S/N 172S8098 N6881XWestmoreland Dennis F · Snyder, TXBuilt 1960 · S/N 17247781 N6883AOswego Joint Venture · Tchula, MSBuilt 1956 · S/N 28983 N6884HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265625 N6885HRasmussen Stewart · Santa Barbara, CABuilt 1975 · S/N 17265626 N6886HParr Larry · Clarksville, TNBuilt 1975 · S/N 17265627 N6887ABradshaw Gary E · Warfordsburg, PABuilt 1956 · S/N 28987 N6888HN6888h LLC · Wayne, NJS/N 17265628 N6889XSchler Joseph B · Reno, NVBuilt 1960 · S/N 17247789 N688AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2008 · S/N 172S10821 N688CABetter Southlake Properties LLC · Pagosa Springs, COS/N 17262505 N688DDPropit Inc · Wilmington, DES/N 17251057 N688DWRegistration Pending · Concord, NHRegistration pendingBuilt 2000 · S/N 17280949 N688WBaum Eldon L Jr · Wellsville, PABuilt 1956 · S/N 28695 N6891HRegistration Pending · Uvalde, TXRegistration pendingBuilt 1975 · S/N 17265630 N6893AFarris Lyle E · Faucett, MOBuilt 1956 · S/N 28993 N6894ASw Aero Training LLC · Rio Rancho, NMBuilt 1956 · S/N 28994 N6895ADettman Gary L · Spearfish, SDBuilt 1956 · S/N 28995 N6896ABuben Michael · Chandler, AZBuilt 1956 · S/N 28996 N6896HBuiqui Aerospace Corp · Kissimmee, FLBuilt 1975 · S/N 17265635 N6897AChancey Amy Victoria · Patterson, GABuilt 1956 · S/N 28997 N6898ADashiell Shawn T · Fairfield, WAS/N 28998 N6898HS J Holding LLC · Wilmington, DES/N 17265636 N689CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13066 N689JATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13589 N68BDBuiqui Aerospace Corp · Kissimmee, FLBuilt 1980 · S/N 17273907 N68FFPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 172S12934 N6900ANorthwind Flying Club · Traverse City, MIBuilt 1956 · S/N 29000 N6901ASpence Stephen L · Anchorage, AKBuilt 1956 · S/N 29001 N6901HRieser Steven E II · Baltimore, OHS/N 17265637 N6902ABasher Michael H · Morehead City, NCBuilt 1956 · S/N 29002 N6902XPoules Alexander · Hope Valley, RIBuilt 1960 · S/N 17247802 N6903AFisher Joe S · Smithville, MOBuilt 1956 · S/N 29003 N6905HTang Flyer LLC · Wausau, WIBuilt 1975 · S/N 17265638 N6906XDucharme Lynn S · Polson, MTBuilt 1960 · S/N 17247806 N6907XCamp Paul L · Fort Wayne, INBuilt 1960 · S/N 17247807 N6908ACarreiro Alexander · Doral, FLBuilt 1956 · S/N 29008 N6910ACook Mike R · Rye, COBuilt 1956 · S/N 29010 N6910XRegistration Pending · Mcpherson, KSRegistration pendingS/N 17247810 N6911ABryson John C III · Bath, NYBuilt 1956 · S/N 29011

Back to AD 90-06-03 R1