OpenAirDocs.org
AD 2012-11-06

Registered aircraft · 84

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

N10123Sandy Wings LLC · Wilmington, DEBuilt 1971 · S/N 107N104VVAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 53N105TBAir Force Material Command Esc/Dikl · Hanscom Afb, MABuilt 1968 · S/N 31N118JKRegistered aircraftBuilt 1984 · S/N 445N127GKAlliance Aviation Group LLC · Wilmington, DES/N 311N137GJSolomon Mark Trustee · Wilmington, DEBuilt 1968 · S/N 25N148VEastern Pine Enterprises LLC · Charlotte, NCS/N 54N163PAN163pa LLC · Wilmington, DEBuilt 1982 · S/N 249N164PAPhoenix Air Group Inc · Cartersville, GABuilt 1979 · S/N 257N165PARca LLC · Wilmington, DEBuilt 1969 · S/N 775N173PAN173pa LLC · Wilmington, DEBuilt 1982 · S/N 313N175BGMile High Holdings LLC · Miami, FLBuilt 1983 · S/N 396N178BMissile Defense Agency (Mda) · Tulsa, OKBuilt 1973 · S/N 125N17LKAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 431N183PASandy Wings LLC · Wilmington, DEBuilt 1984 · S/N 385N184PABartowjets LLC · Wilmington, DEBuilt 1981 · S/N 318N190PASandy Wings LLC · Wilmington, DES/N 320N195PASandy Wings LLC · Wilmington, DEBuilt 1983 · S/N 399N196PASandy Wings LLC · Wilmington, DES/N 321N198PABartowjets LLC · Wilmington, DEBuilt 1986 · S/N 482N2000Global Avionics LLC · Downey, CAS/N 56N202PXZ & L Consulting LLC · Midland, TXS/N 17N218EESolomon Mark Trustee · Wilmington, DEBuilt 1986 · S/N 489N222NPAircraft Fidelity Corp Trustee · Dover, DES/N 245N227LAK&A Advisors LLC · Wilmington, DEBuilt 1976 · S/N 193N234LRDanish Jet Inc Trustee · Cheyenne, WYBuilt 1980 · S/N 300N24YSRegistered aircraftBuilt 1968 · S/N 16N303MPAir Cargo Services LLC · Miami, FLS/N 390N30501Dutchess Community College · Poughkeepsie, NYS/N 383N305LRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 305N30HEClassic Aircraft Aviation Museum Inc · Hillsboro, ORBuilt 1967 · S/N 51N30LXN492a LLC · Goodyear, AZBuilt 1984 · S/N 438N30WRInfotech Management Inc · San Diego, CANon-citizen corporation, flight hours not reportedBuilt 1983 · S/N 380N313MSEpic Rise LLC · Tulsa, OKS/N 372N320MKAdaka-Sb LLC · Orlando, FLBuilt 1982 · S/N 370N324JWVip Jet Transportation Inc · Bishop, CABuilt 1981 · S/N 324N32MJAviation Company Inc · Cheyenne, WYBuilt 1982 · S/N 460N337LRJetsteam Aviation Inc · Cheyenne, WYBuilt 1981 · S/N 337N356BRBdp Airways LLC · Dover, DEBuilt 1982 · S/N 356N358CYBondio LLC · Great Neck, NYS/N 358N36DZSmb Giii LLC · Longwood, FLBuilt 1984 · S/N 450N36PNB&G Leasing LLC · Wilmington, DEBuilt 1969 · S/N 42N388MMAc Travel LLC · Palm Beach, FLBuilt 1986 · S/N 490N3DPAircraft Holding Solutions LLC · Newark, DEBuilt 1981 · S/N 334N404AAPacific Rim Management LLC · Downey, CABuilt 1982 · S/N 362N413WJN492a LLC · Goodyear, AZS/N 463N416WMKen Sale Resource Inc · Southlake, TXS/N 487N44HBBartowjets LLC · Wilmington, DEBuilt 1984 · S/N 437N456BEBillionaire Inc · St Petersburg, FLBuilt 1981 · S/N 335N457JCExceptional Aircrafts LLC · Mcallen, TXS/N 457
Back to AD 2012-11-06