Skip to content

Registered aircraft · 115

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

N106CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1020 N120PCHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0079 N132RXJ + D Aviation Services LLC · Centerville, MAS/N 402C0609 N160PBHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0493 N168WACharles Michel · St Thomas, VIBuilt 1984 · S/N 402C0808 N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116 N205CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0207 N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105 N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637 N256CAHyannis Air Service Inc · Hyannis, MAS/N 402C0606 N258PBHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0336 N2610GBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 402C0064 N2611XHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0072 N2614LCharter Flights Caribbean Inc · San Juan, PRBuilt 1979 · S/N 402C0092 N26156Hyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0112 N2615GHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0101 N2615QVenture Air Solutions Inc · Opa Locka, FLBuilt 1980 · S/N 402C-0321 N2649ZHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0333 N26514Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0344 N2651SHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0342 N267CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0030 N270RCEagle 1-N270rc LLC · San Juan, PRBuilt 1980 · S/N 402C0269 N2712FDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 402C0121 N2715TDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 402C0214 N2718YRichland Aviation Inc · Sidney, MTBuilt 1979 · S/N 402C0232 N274MRAero Systems Inc · Broomfield, COBuilt 1980 · S/N 402C0274 N275RCGianopoulous William · Lawrence, MABuilt 1979 · S/N 402C0117 N290CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0297 N322HAAir Flight Inc · Fort Lauderdale, FLS/N 402C0418 N3249MHyannis Air Service Inc · Hyannis, MAS/N 402C0296 N3292MHyannis Air Service Inc · Hyannis, MAS/N 402C0304 N346CHAce Flight Center Inc · St Thomas, VIBuilt 1979 · S/N 402C0029 N347ABTropical Transport Services Ltd Inc · San Juan, PRBuilt 1980 · S/N 402C0347 N351ABTropical Transport Services Ltd · San Juan, PRBuilt 1980 · S/N 402C0351 N36908Williams D Eric · Palm Springs, FLBuilt 1980 · S/N 402C0313 N36911Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0314 N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468 N385CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0111 N38CJAirplane Seven LLC · Watkins, COBuilt 1978 · S/N 402C0023 N400ATAlpha Tango Aviation Inc · Middletown, DEBuilt 1981 · S/N 402C0510 N401SXHyannis Air Service Inc · Hyannis, MAS/N 402C0447 N401TJHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0109 N402BKN402bk LLC · Nantucket, MABuilt 1978 · S/N 402C0689 N402HGHyannis Air Service Inc DBA · Hyannis, MABuilt 1985 · S/N 402C1016 N402JHAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0500 N402RSTropical Transport Services Ltd · San Jaun, PRBuilt 1980 · S/N 402C0402 N402SAAlly Mohamed Yacoob · Fort Lauderdale, FLS/N 402C0623 N402SBGlemone Airways Inc · Wilmington, DEBuilt 1979 · S/N 402C0082 N402VNHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0488 N402VPVespa Power Products LLC · Visalia, CAS/N 402C0025

Back to AD 99-11-13