Skip to content

Registered aircraft · 479

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:2005-12-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:2005-12-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:2005-12-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:2005-12-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:2005-12-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:2005-12-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.

N2734GSplit Rock Aerospace LLC · Southport, CTBuilt 1979 · S/N 414A0456 N2735JAlpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0466 N2744XAccelerated Slipstream LLC · Livermore, CABuilt 1981 · S/N 414A0812 N27457Felix Margarita G · Nogales, AZBuilt 1981 · S/N 414A0813 N2745GKj3 Air LLC · Mitchell, SDBuilt 1980 · S/N 414A0622 N274MRAero Systems Inc · Broomfield, COBuilt 1980 · S/N 402C0274 N275RCGianopoulous William · Lawrence, MAFirst renewal noticeBuilt 1979 · S/N 402C0117 N27CLC2 Beach St Holdings LLC · Ormond Beach, FLS/N 414A0636 N28APAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1978 · S/N 414A0204 N28CCGulf Airbatics Ltd · Jennings, LABuilt 1979 · S/N 414A0226 N290CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0297 N291RBAbbott Air Inc · Hydro, OKBuilt 1982 · S/N 414A0836 N292RSValiair Limited Company Trustee · Casper, WYBuilt 1980 · S/N 414A0482 N300CGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0121 N300SQVortex Aviation LLC · Houston, TXBuilt 1979 · S/N 414A0416 N301CPWhy Not Fly Aviation LLC · Gainesville, VAS/N 414A0105 N306PMBc 414 LLC · Vineyard Haven, MABuilt 1979 · S/N 414A0419 N30EEEnterprises Aviation Inc · Piedmont, SDBuilt 1979 · S/N 414A0443 N30FBBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N 414A0067 N311BTBob Air LLC · Concord, MAS/N 414A0453 N317MZValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 414A-0633 N320SWEast West Investment Advisors LLC · Sandy Point, VABuilt 1980 · S/N 414A0451 N3216MN3216m Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0826 N321JHSkidmore Gary DBA · Terreton, IDBuilt 1978 · S/N 414A0063 N322HAAir Flight Inc · Fort Lauderdale, FLS/N 402C0418 N322RMPhillips George Thomas · Carson City, NVBuilt 1981 · S/N 414A0827 N3249MHyannis Air Service Inc · Hyannis, MAS/N 402C0296 N325KCMount Wilson Holdings LLC · Orange, CABuilt 1981 · S/N 414A0825 N327MWW. Morrison Consulting Group Inc · Aliso Viejo, CABuilt 1980 · S/N 414A0531 N3292MHyannis Air Service Inc · Hyannis, MAS/N 402C0304 N333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 414A0525 N335CMPura Plastic Surgery LLC · Doral, FLBuilt 1980 · S/N 414A0418 N33WVInarayan Inc · Winter Park, FLS/N 414A0082 N346CHAce Flight Center Inc · St Thomas, VIBuilt 1979 · S/N 402C0029 N347ABTropical Transport Services Ltd Inc · San Juan, PRBuilt 1980 · S/N 402C0347 N350GMCannonball Trucking Inc · Houston, TXBuilt 1978 · S/N 414A-0120 N351ABTropical Transport Services Ltd · San Juan, PRBuilt 1980 · S/N 402C0351 N351HCBig Elk Aviation LLC · Elk City, OKS/N 414A0801 N366MN366m LLC · Dover, DES/N 414A0026 N366MCHastings Steve T · Corpus Christi, TXS/N 414A1005 N36887Aa Aircraft Adventure LLC · Joplin, MOBuilt 1982 · S/N 414A0835 N36908Williams D Eric · Palm Springs, FLBuilt 1980 · S/N 402C0313 N36911Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0314 N36961Alpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0494 N37181Jrs Aviation LLC · Falls City, NEBuilt 1980 · S/N 414A0511 N37543Construction Solutions & Consulting LLC · Sedalia, MOS/N 414A0002 N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468 N379TWTanglewood Aviation LLC · Fort Mill, SCBuilt 1981 · S/N 414A-0616 N37FSLuxury Transportation LLC · Talladega, ALS/N 414A0830 N37UJet Set Aircraft Inc · Van Nuys, CABuilt 1977 · S/N 414A0010

Back to AD 2005-12-13