Registered aircraft · 1,493

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-13-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-13-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-13-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-13-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-13-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-13-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 N100AJN8006j LLC · Shiloh, ILBuilt 1972 · S/N 421B0322 N100AZNnww Holdings LLC · San Angelo, TXS/N 421C1051 N100CXCs Leasing LLC · Rockville, MDBuilt 1980 · S/N 414A0623 N100JDMark Aviation LLC · Kingsport, TNBuilt 1981 · S/N 414A0669 N100JLBytelogics Inc · New York, NYS/N 421-0008 N100LCozumel Leasing LLC · Wilmington, DEBuilt 1977 · S/N 421C0313 N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429 N101MEIbs America Corp · Wilmington, DEBuilt 1969 · S/N 401A0130 N101TAHatch Hyrum G · Gilbert, AZBuilt 1977 · S/N 421C0331 N1027DRobins Jack S · Saint Charles, IDBuilt 1968 · S/N 421-0196 N103ECAerial Surveys International LLC · Watkins, COBuilt 1967 · S/N 401-0135 N103JGRam Aero Development Inc · Waco, TXBuilt 1979 · S/N 414A0264 N104WMHamilton Aviation LLC · Morehead, KYBuilt 1975 · S/N 421B0964 N105KAGillespie Todd · Trenton, SCS/N 401-0238 N108LVVandermolen Louis A Md · Laguna Beach, CAS/N 414A0841 N10FFValiair Lc Co Trustee · Casper, WYBuilt 1976 · S/N 421C0082 N110DHYingling Consultation LLC · Wilmington, DES/N 421B0137 N110VEHorizon Group Inc Trustee · Boca Raton, FLBuilt 1977 · S/N 414A-0017 N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368 N111TFPacific Aviation Aircraft Management Inc · Ontario, ORBuilt 1974 · S/N 421B0660 N111TLNdk Global Holdings Corp · Dover, DEBuilt 1974 · S/N 421B0645 N112ALPassport Auto & Aviation Inc · Richmond, VABuilt 1979 · S/N 421C0697 N112MJTm Aero LLC · Riverview, FLS/N 421C0907 N113GLBushwacker Aviation LLC · Benton, ARBuilt 1978 · S/N 414A0072 N113MPBan Air LLC · Boerne, TXBuilt 1982 · S/N 421C1235 N1141XChancellor Aviation LLC · Billings, MTBuilt 1978 · S/N 414A0215 N114HVAerowerks LLC · Georgetown, TXBuilt 1973 · S/N 421B0371 N114MHVlavic Aviation LLC · Hallandale Beach, FLBuilt 1979 · S/N 414A0458 N116JJProgress Aviation LLC · Ellicott City, MDBuilt 1984 · S/N 421C1404 N116PAJht Aircraft LLC · Wilmington, DEBuilt 1978 · S/N 414A0021 N119PARicciardi Brian P · Hyannis, MAS/N 402B0610 N119SKKing Air 3au LLC · Wichita, KSS/N 414A0660 N11BNAlpha 414a LLC · New Smyrna Beach, FLBuilt 1979 · S/N 414A0311 N1203GWestern Pilot Service Inc · Phoenix, AZBuilt 1975 · S/N 414-0649 N1206KOnuzo Chika N · Fayetteville, GAS/N 421C1804 N1206NCapital Group Inc · Garden City, IDBuilt 1985 · S/N 421C1805 N1214G9791m LLC · Tacoma, WABuilt 1975 · S/N 414-0652 N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653 N121AQPacker William M III Trustee · Orchard Lake, MIS/N 421C1063 N121BDKorn Air LLC · Fort Lauderdale, FLS/N 414A0297 N1223HS&S Leasing Solutions LLC · Sandy Springs, GABuilt 1973 · S/N 421B0365 N122SWAmerican Petroleum Corp · Ratliff City, OKS/N 421B0506 N1234WCuellar Mauricio Dominguez · Tampa, FLBuilt 1970 · S/N 414-0043 N123BARothschild Jonathan Trustee · Tucson, AZS/N 414A-0065 N123BTYingling Consultation LLC · Wilmington, DEBuilt 1973 · S/N 421B0414 N123NPTralo Aviation LLC · Owatonna, MNBuilt 1977 · S/N 421C0402 N12434Aviation S And S LLC · Miami, FLBuilt 1983 · S/N 414A1002 N1245AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 414A1201 N124TMUniversal Aviation LLC · Decatur, ARS/N 421C-0898

Back to AD 76-13-07