Skip to content

Registered aircraft · 1,379

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:70-10-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:70-10-06') 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:70-10-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:70-10-06')
  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:70-10-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:70-10-06')
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.

N102LAIowa Lakes Community College · Estherville, IAS/N 17259038 N111TKMclendon Thomas A · Crockett, TXBuilt 1968 · S/N 17257828 N1170MBryson William H III · Cook, MNBuilt 1969 · S/N 17258670 N1172MTodd Kevin E · Bismarck, NDBuilt 1969 · S/N 17258672 N1173MFlathead Lake Aviation LLC · Polson, MTBuilt 1969 · S/N 17258673 N1174MWhitted Danny E · Candler, NCBuilt 1969 · S/N 17258674 N1178MLehman David G · Kent, WABuilt 1969 · S/N 17258678 N1179MBartholomew Thomas C · Stanwood, WABuilt 1969 · S/N 17258679 N1180MFlying Weaners Inc · Jacksonville, FLBuilt 1969 · S/N 17258680 N1181MChin David · San Jose, CABuilt 1969 · S/N 17258681 N1182MHilton David T · Brooksville, FLBuilt 1969 · S/N 17258682 N1185MOwen Steve · White City, ORBuilt 1969 · S/N 17258685 N1187MMorgan Donald F · Reno, NVBuilt 1970 · S/N 17258687 N1188MTrim Tab LLC · Fort Collins, COBuilt 1969 · S/N 17258688 N1190MDorr Daniel B · Locust Grove, GABuilt 1969 · S/N 17258690 N1191MMoore John S · Tracy, CABuilt 1969 · S/N 17258691 N1192MGaruda Aviation Inc · Miami, FLBuilt 1969 · S/N 17258692 N1193MEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17258693 N1194MGadamic LLC · Fresno, CABuilt 1969 · S/N 17258694 N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698 N121GBAviation Academy LLC · Wichita, KSBuilt 1968 · S/N 17257308 N1222LBoland Charles R · Blairsville, GABuilt 1969 · S/N 17258385 N123FCCurtis James · Abilene, KSBuilt 1970 · S/N 17259182 N124RCEc Aviation Inc · Stockbridge, GABuilt 1970 · S/N 17258537 N126KWersinger Duncan · Rochester, NYBuilt 1968 · S/N 17257392 N128CGMontaez Torrez Raul · Guaynabo, PRBuilt 1968 · S/N 17256621 N128RVande Hei Joshua G · Kaukauna, WIBuilt 1968 · S/N 17256984 N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055 N14BLEagle Equity Inc · Valparaiso, INBuilt 1968 · S/N 17257735 N14NFStiles Terry D · King Salmon, AKBuilt 1968 · S/N 17256844 N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075 N15GWFlight Brothers LLC · Sachse, TXBuilt 1969 · S/N 17258161 N15NFRegistered aircraftBuilt 1969 · S/N 17258204 N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875 N169AJNolan Davis Dds LLC · Juneau, AKBuilt 1969 · S/N 17257981 N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618 N16WLLivingston Patricia R · Wasilla, AKS/N 17256545 N172ADRust Michael David · Rush City, MNBuilt 1969 · S/N 17258365 N172BACarrolls Auto And Aircraft Sales LLC · Muncie, INS/N 17259091 N172BMBarrett Jacob D · Paris, ILBuilt 1968 · S/N 17256780 N172BTBroderick Edward P · Halifax, MABuilt 1970 · S/N 17258936 N172CJAlsworth Caleb J · Port Alsworth, AKBuilt 1968 · S/N 17257173 N172DVLima Tango Aviation LLC · Mount Dora, FLBuilt 1968 · S/N 17256625 N172ESAero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258019 N172FMStern Jason C · Roscoe, ILBuilt 1969 · S/N 17258008 N172GCDairy Air Inc · Wyoming, PABuilt 1968 · S/N 17257234 N172HLStankiewicz Adam · Merrimack, NHBuilt 1970 · S/N 17259079 N172HTAuto Outlet Of Irvington LLC · Irvington, NJS/N 17257091 N172JGGroendyke Jerry G · Fort Pierce, FLBuilt 1969 · S/N 17257987 N172JLSutton Aircraft Salvage LLC · Palmer, AKS/N 17257724

Back to AD 70-10-06