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.

N3926GSellman Richard L · Missoula, MTS/N 340A0236 N3936GBaker George G · Junction City, ORBuilt 1976 · S/N 340A0237 N3938GHaverlock Aircraft LLC · Richmond Heights, OHS/N 340A0239 N3959GUniversal Aviation LLC · Decatur, ARS/N 340A0243 N3960GLubard Stephen C · Woodland Hills, CAS/N 340A0244 N3963GKohsel Aviation LLC · Holland, MIS/N 340A0246 N3980GGoods Thomas Jr · Romulus, MIS/N 340A0252 N3981GSilver David S · Brookings, ORS/N 340A0253 N3983GBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 340A0255 N39DDLarson Danny O · Palmer, AKBuilt 1973 · S/N 340-0246 N3ELTwo If Buy LLC · Nashua, NHBuilt 1978 · S/N 340A0525 N3HKInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340-0538 N3LNAllen Jeffrey W · Crestwood, KYBuilt 1973 · S/N 340-0301 N400APZoie Air LLC · Fort Lauderdale, FLBuilt 1974 · S/N 340-0345 N4043GGalaxy Aviation Services LLC · Orlando, FLBuilt 1977 · S/N 340A0266 N4051CSky High Ventures LLC · Bartlett, TNBuilt 1980 · S/N 340A0995 N4065GCruz-Alvarez Raul Trustee · Miami Springs, FLS/N 340A0268 N4091GRobinson Brant Fitzgerald · Powder Springs, GABuilt 1977 · S/N 340A0275 N40GBSlb Enterprises LLC · Newark, DEBuilt 1977 · S/N 340A0264 N40SSAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 340A0650 N4116GAcaats LLC · Queen Creek, AZBuilt 1977 · S/N 340A0288 N411STwin Adventures LLC · Cincinnati, OHBuilt 1972 · S/N 340-0099 N411VTvc Aviation Inc · Lebanon, OHBuilt 1973 · S/N 340-0250 N4125GSeeding Operations And Atmospheric Research (Soar) · San Angelo, TXBuilt 1977 · S/N 340A0297 N4130GJannelli Frank L · Fort Myers, FLS/N 340A0301 N4139GMuth Transportation Inc · Stanton, CAS/N 340A0310 N413WWWilkinson Jason S · Eastvale, CABuilt 1972 · S/N 340-0176 N4140GCaribbean Development Partnership Ltd · Wilmington, DEBuilt 1977 · S/N 340A0311 N4144GMidmichigan Cardiology Pc · Gladwin, MIS/N 340A0314 N4148GKutrieb Wolfgang Michael · Chetek, WIBuilt 1977 · S/N 340A0318 N4150GWeb LLC · Springfield, VAS/N 340A0320 N4151G4151g LLC · Lima, OHS/N 340A0321 N415WZCrimson Leasing LLC · Lenexa, KSBuilt 1978 · S/N 340A0602 N4171QN4171q LLC · Newport Beach, CABuilt 1972 · S/N 340-0094 N418TRAir Sunrise LLC · Mountain View, CABuilt 1982 · S/N 340A1525 N41BGRaising Lazarus LLC · Farmington, NMS/N 340A0305 N41NRSholy Fred · Granada Hills, CAS/N 340A0488 N423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 1981 · S/N 340A1270 N424MEKfl LLC · Canyon Country, CABuilt 1976 · S/N 340A0051 N424PCMontana Livestock Ag Credit Inc · Helena, MTS/N 340A1266 N425RGUpstate Aircraft LLC · Old Forge, NYS/N 340A0976 N4264CMmc Properties LLC · Cottonwood, AZBuilt 1978 · S/N 340A0516 N4287AWilliam Dolson And Associates LLC · Santa Fe, NMBuilt 1980 · S/N 340A1010 N4304CN4304c LLC · Pawhuskah, OKBuilt 1980 · S/N 340A1011 N4315COld Salt Aviation LLC · Virginia Beach, VABuilt 1978 · S/N 340A0532 N4326CSeven Echo Whiskey Corp · Wilmington, DEBuilt 1976 · S/N 340A0075 N432RADirect Entry Holdings LLC · Port Richey, FLBuilt 1979 · S/N 340A0925 N438APWhiskey 340 LLC · Tucson, AZBuilt 1977 · S/N 340A0438 N43DAAero Management Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 340A0112 N4403ABank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 340A1014

Back to AD 81-07-11 R1