Skip to content

Registered aircraft · 467

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

N1008AAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 402-0097 N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429 N101MEIbs America Corp · Wilmington, DEBuilt 1969 · S/N 401A0130 N103ECAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 401-0135 N105KAGillespie Todd · Trenton, SCS/N 401-0238 N106CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1020 N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368 N119PARicciardi Brian P · Hyannis, MAS/N 402B0610 N1203GWestern Pilot Service Inc · Phoenix, AZBuilt 1975 · S/N 414-0649 N120PCHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0079 N1214G9791m LLC · Tacoma, WABuilt 1975 · S/N 414-0652 N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653 N1234WCuellar Mauricio Dominguez · Tampa, FLBuilt 1970 · S/N 414-0043 N1252GInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 414-0809 N126BTSecure Storage Solutions LLC · Thomaston, GABuilt 1977 · S/N 4140909 N12QHawkes F Bryant · Lake Dallas, TXBuilt 1966 · S/N 401-0014 N132RXJ + D Aviation Services LLC · Centerville, MAS/N 402C0609 N142SDSch Aviation Inc Trustee · Kings LynnBuilt 1975 · S/N 414-0635 N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333 N14UAMilam Equipment LLC · Trussville, ALS/N 414-0605 N1500G5 Lg LLC · Rome, GABuilt 1975 · S/N 414-0814 N154TTHotel Sierra Aviation LLC · Texarkana, TXS/N 414-0950 N1554TWilliston Aviation Group LLC · Morriston, FLBuilt 1972 · S/N 414-0269 N1556TCalifornia Energy Exchange Corp · Rancho Cordova, CABuilt 1972 · S/N 414-0271 N1557TCessna 414 LLC · Lincoln, NEBuilt 1972 · S/N 414-0272 N1563TN1563t LLC · Sheridan, WYS/N 414-0278 N1596TPlane Crazy Inc · Page, NDBuilt 1973 · S/N 4140376 N1600TBpm Rentals Inc · Lincoln, CABuilt 1973 · S/N 414-0380 N1603TMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1973 · S/N 414-0383 N160PBHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0493 N1616TDavila Alexander · Davie, FLS/N 414-0396 N1618TRandolph James · Greensburg, PABuilt 1973 · S/N 414-0398 N1621TBeats Driving Inc · Northbrook, ILBuilt 1973 · S/N 414-0401 N1624TMelnik Charles J DBA · Omaha, NES/N 414-0404 N1627TSierra Leasing LLC · Sheffield, ALBuilt 1973 · S/N 414-0407 N1637TSmith Taylor · Amarillo, TXBuilt 1973 · S/N 414-0417 N1646TOrellana Willson Daniel · Hesperia, CABuilt 1973 · S/N 414-0426 N1652TBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 414-0432 N1668TKevu Aviators LLC · Maryville, MOBuilt 1973 · S/N 414-0461 N1670THyde Family Aviation LLC · Wilmington, DEBuilt 1973 · S/N 414-0463 N1678TGabaldon Martin · El Paso, TXS/N 414-0471 N167WAGrid Aero Inc · San Leandro, CABuilt 1976 · S/N 402B1044 N168WACharles Michel · St Thomas, VIBuilt 1984 · S/N 402C0808 N175KBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 401B0206 N17AMFarmdog Aviation LLC · Lafayette, INBuilt 1974 · S/N 414-0524 N1842SFry William A · Willmar, MNBuilt 1973 · S/N 414-0433 N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394 N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116 N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544 N1995GHarris Justin R · Hico, TXBuilt 1974 · S/N 414-0602

Back to AD 76-16-07