Registered aircraft · 765

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

N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12 N100PYTbm Flying Lc · Pampa, TXBuilt 1981 · S/N BB-890 N100TWTexas La Flyers LLC · Monroe, LABuilt 1978 · S/N BE-51 N100VQNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 140 N101SNGorsuch Aviation LLC · Lancaster, OHBuilt 1981 · S/N BE-118 N102BMeyjes Gijsbert Posthumus · Cadillac, MIS/N 337-0024 N106RHSouthern Bracing Systems Inc · Armuchee, GABuilt 1978 · S/N BB-428 N107DBSkymaster Stc LLC · Mena, ARS/N P3370034 N108ALRj Flight LLC · Saint Petersburg, FLBuilt 1980 · S/N BB-730 N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40 N108CCFlaugher Jonathan S · Poquoson, VABuilt 1965 · S/N 3370202 N108EBAndrie Inc · Muskegon, MIBuilt 1980 · S/N BE-108 N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109 N10AGBaron Associates LLC · Norfolk, VABuilt 1980 · S/N BE-100 N110GGo Soar LLC · Highland Village, TXBuilt 1980 · S/N BB-792 N110RLProctor Charles L · Alachua, FLBuilt 1973 · S/N P3370095 N110SMPenhall Michael Joseph · Lake Forest, CABuilt 1964 · S/N 337-0023 N111PVHenson Builders LLC · Dallas, TXBuilt 1981 · S/N BB-772 N116DGStructures Inc · Mesa, AZBuilt 1981 · S/N BE-116 N118NLPandd Partnership LLC · Oro Valley, AZBuilt 1981 · S/N BE-111 N119BARegistration Pending · Tucson, AZRegistration pendingBuilt 1965 · S/N 23-084 N11WSAviation Trust Company LLC · Oklahoma City, OKS/N P3370017 N121LBEastern Stearman Inc Trustee · Leesburg, VAS/N BB-475 N124KTGams Air LLC · Doral, FLBuilt 1976 · S/N BB-124 N124WRH.A.I. Services Inc · Justin, TXBuilt 1980 · S/N BB-664 N125BKColoramo Federal Credit Union · Grand Junction, COBuilt 1982 · S/N BB-977 N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595 N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312 N127TACompany Wrench Ltd · Carroll, OHBuilt 1980 · S/N BB-636 N127TXItb Solutions LLC · Palm City, FLBuilt 1981 · S/N BE-106 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N12NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 1979 · S/N BB-581 N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80 N1314SAviation Specialty Services LLC · Beaufort, NCS/N 33701902 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N1337LAviation Specialty Services LLC · Beaufort, NCBuilt 1977 · S/N 33701829 N1346LAtwell Air LLC · Grundy, VABuilt 1977 · S/N 33701838 N1353LAviation Specialty Services LLC · Beaufort, NCBuilt 1978 · S/N 33701845 N1375LAviation Specialty Services LLC · Beaufort, NCBuilt 1978 · S/N 33701867 N137MCPoland Gilbert Guardian · Dothan, ALBuilt 1965 · S/N 337-0127 N1384LCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1978 · S/N 33701876 N1385LWhiskey River Aviation LLC · Medford, ORBuilt 1978 · S/N 33701877 N1390LGreen Rose LLC · Swartz Creek, MIBuilt 1978 · S/N 33701882 N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81 N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177 N13FTFenix Private Capital Group LLC · Phoenix, AZS/N P3370245 N1425MRhino Capital Holdings LLC · Bonaire, GABuilt 1974 · S/N P3370162 N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585 N143JBKing John · Torrance, CABuilt 1965 · S/N 337-0102 N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59

Back to AD 78-20-12