Skip to content

Registered aircraft · 733

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:81-07-11-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:81-07-11-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:81-07-11-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:81-07-11-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:81-07-11-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:81-07-11-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.

N340NGCentral Virginia Aviation Inc · Petersburg, VAS/N 340-0042 N340PCDouble J Aviation LLC · Burlington, WIBuilt 1979 · S/N 340A0962 N340PFSharon Leasing Co · Ludington, MIBuilt 1977 · S/N 340A0225 N340PJPremier Jets Inc · Hillsboro, ORBuilt 1975 · S/N 340-0539 N340PLSummit Aircraft Sales LLC · Akron, OHS/N 340-0546 N340PPRegistered aircraftBuilt 1979 · S/N 340A0747 N340PRFly Yawa Aviation LLC · Statesboro, GABuilt 1976 · S/N 340A0123 N340PTMach Air LLC · Townsend, GABuilt 1972 · S/N 340-0014 N340PWValiair Limited Co Trustee · Casper, WYS/N 340A0933 N340RASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 340A0038 N340RBCorcoran Kim C Trustee · Burrton, KSBuilt 1978 · S/N 340A0498 N340RDDeaton Courtney · London, KYS/N 340-0019 N340RFN340rf LLC · Denver, COBuilt 1976 · S/N 340A0212 N340RGSteggs Garret E · Edmond, OKBuilt 1973 · S/N 340-0239 N340RHMy Toy Box Inc · Debary, FLBuilt 1972 · S/N 340-0086 N340RJStohr Jeffry M · Aberdeen, SDS/N 340A0273 N340RPMeister Scott R · Skillman, NJBuilt 1979 · S/N 340A0733 N340RRCustom Data Engineering Inc · Phoenix, AZS/N 340-0107 N340RSWestermeyer Holdings LLC · Longville, MNBuilt 1977 · S/N 340A0371 N340SBStarlight Express LLC · Bellevue, WABuilt 1979 · S/N 340A0724 N340SDRegistration Pending · Kaukauna, WIRegistration pending, pending cancellationS/N 340A0408 N340SGN340sg Leasing LLC · Sheridan, WYBuilt 1980 · S/N 340A0973 N340SHHenderson Scott · Tucson, AZBuilt 1978 · S/N 340A0548 N340STSchlabach Herman · Belton, TXBuilt 1978 · S/N 340A0528 N340SUDm Air Ltd · Newark, OHS/N 340A0979 N340SVQuetzal Aviation Corp · Washington, DCBuilt 1980 · S/N 340A1003 N340TARmb Leasing Inc · Dover, DEBuilt 1979 · S/N 340A0648 N340TBBerkshire Building Services Inc · South Egremont, MABuilt 1976 · S/N 340A0066 N340TG340tg LLC · Elm Springs, ARS/N 340A0730 N340THHinkle Anthony · Mineola, TXS/N 340A0501 N340TLRegistration Pending · Henderson, NVRegistration pendingBuilt 1975 · S/N 340A0018 N340TSNighthawk Flight Systems Inc · Vista, CABuilt 1980 · S/N 340A0999 N340TTPrecision Aviation LLC · Costa Mesa, CABuilt 1980 · S/N 340A1034 N340UGonzalez Pablo II · Sweeny, TXBuilt 1978 · S/N 340A0530 N340UMSouthwest Management Group Inc · Farmington, NMBuilt 1979 · S/N 340A0698 N340VAMel Hambelton Ford Inc · Wichita, KSBuilt 1979 · S/N 340A0915 N340VCStc Aviation Inc · Saint Cloud, MNS/N 340A0296 N340VLVanguard R&R Lease Co Inc · Dallas, TXBuilt 1984 · S/N 340A1811 N340VVYouth Aviation Academy · Roseville, CABuilt 1972 · S/N 340-0087 N340WPraetorian Aviation Services LLC · Alva, FLBuilt 1973 · S/N 340-0317 N340WAFoshay Laird · Paso Robles, CABuilt 1972 · S/N 340-0035 N340WDKnoxville Air Charter Service LLC · Strawberry Plains, TNBuilt 1974 · S/N 340-0509 N340WGBartlein & Co Inc · Santa Barbara, CABuilt 1972 · S/N 340-0182 N340WHN340dg LLC · Spanish Fork, UTBuilt 1974 · S/N 340-0366 N340WJIntegritas Aviation LLC · Cedar Park, TXBuilt 1979 · S/N 340A0774 N340WMHarco Aviation LLC · Houston, TXBuilt 1978 · S/N 340A0612 N340WPNnk Holdings LLC · San Antonio, TXBuilt 1981 · S/N 340A1240 N340XCPrairie Aero LLC · Baldwin City, KSBuilt 1976 · S/N 340A0098 N340XPN340xp LLC · Wellington, FLS/N 340A0741 N340XXTaylor Christopher A · Phoenix, AZBuilt 1979 · S/N 340A0689

Back to AD 81-07-11 R1