AD 48-08-01

Registered aircraft · 1,077

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

N238SAzure II Flight Time LLC · Leesburg, FLBuilt 1965 · S/N CD-920N239VLomax John E · Powell, TNBuilt 1947 · S/N D-683N23THLudlow Christopher C · Redding, CABuilt 1966 · S/N CD-1019N241HAMcfarland Mark C · Cottage Grove, ORBuilt 1960 · S/N CD-84N242JBMcgregor Todd R · Cincinnati, OHBuilt 1966 · S/N CE-44N250YMyers Mark E · Rogers, ARBuilt 1966 · S/N CD-1065N251GT251gt Corp · Oak View, CAS/N CD-251N252AALadson Timothy L · Savannah, GABuilt 1961 · S/N CD-330N253JC96 Quick LLC · Wilmington, DEBuilt 1963 · S/N CD-673N262WPage Jeffrey Vernon · Washington, PABuilt 1966 · S/N CD-1031N2632PBargabos Richard O · Peterboro, NYBuilt 1960 · S/N CD-114N267CFBarks Kevin L · Dexter, MOS/N D-668N270HBemenderfer Todd M · Mishawaka, INBuilt 1947 · S/N D-681N2717VBlazek James T · Malta, ILBuilt 1947 · S/N D-93N272AAEdj Aviation Limited · Fort Myers Beach, FLBuilt 1960 · S/N CD-34N273Lone Star Sorties LLC · Dickinson, TXS/N D-1340N2736VHatloy Mark A · Drayton, NDBuilt 1947 · S/N D-116N2751VGarrett Gregory Todd · Athens, TXBuilt 1947 · S/N D-136N2754VSheldon Paul T · Saint James, MNS/N D-139N2762VJ R Bane Land Corp · Oakland, IABuilt 1947 · S/N D-153N2766VReady Aim Flyer LLC · New Castle, DEFirst renewal noticeBuilt 1947 · S/N D-157N2768TNorth Wind Aviation LLC · Chelan, WABuilt 1967 · S/N CD-1107N2770THanson Leasing Inc · Bad Axe, MIBuilt 1967 · S/N CD-1104N2772VCathcart Samuel H · Carlisle, OHBuilt 1947 · S/N D-164N2778VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N D-170N2785VGunnarsson Jon · Concrete, WAS/N D-177N2786VHoffner Edward M · Jefferson City, TNBuilt 1947 · S/N D-178N2788THarnden Craig A · Lake City, FLBuilt 1967 · S/N CE-154N2795VBas Part Sales LLC · Greeley, COBuilt 1947 · S/N D-190N2798VPorte Elvis · Miami, FLBuilt 1947 · S/N D-193N27JCTalotta Nicholas J · Ocean City, NJBuilt 1960 · S/N CD-267N27THArizona Cloudbusters Inc · Mesa, AZBuilt 1966 · S/N CD-1015N2804VPlumcrazy Aviation LLC · Ellenboro, NCBuilt 1947 · S/N D-201N2813VAdair Edward A · Hemet, CABuilt 1947 · S/N D-214N2819VElgin Sky Snoopers Inc. · Crystal Lake, ILBuilt 1947 · S/N D-221N2820VLundstedt Garry R · Fort Collins, COBuilt 1947 · S/N D-222N2821VSchmitt Rudy · Brookshire, TXBuilt 1947 · S/N D-225N2824VBigfoot Aviation LLC · Saint Michael, MNBuilt 1947 · S/N D-228N2827TRegan Keith M · Torrance, CABuilt 1965 · S/N CD-953N2834VKieper Mark A · Hampton, MNBuilt 1947 · S/N D-239N2846VRegistration Pending · Shawnee, OKRegistration pendingS/N D-251N284AAFarwell William B · Benton, PABuilt 1960 · S/N CD-189N2855VBunka Donald P · Fenton, MIBuilt 1947 · S/N D-260N2858VMyers Alyssa L · Clayton, NMS/N D-263N285BWWatson Alex · Chadron, NEBuilt 1961 · S/N CD-400N2860VNord Aviation Inc · Pembina, NDBuilt 1947 · S/N D-265N2861VBeck Roger M Trustee · Goode, VABuilt 1947 · S/N D-266N2868VBiehle Michael A · Yuba City, CAFirst renewal noticeBuilt 1947 · S/N D-273N2870VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1947 · S/N D-275N287JGGully John F · Brooklyn, NYBuilt 1965 · S/N CD934
Back to AD 48-08-01