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.

N1742GLoftus Kevin · Pasadena, CABuilt 1962 · S/N CD-467N1747GPalmenteri Louis J · Rhome, TXBuilt 1962 · S/N CD-492N1748GRobar Aircraft Inc · Griffin, GABuilt 1962 · S/N CD-527N174JJRensi William C · Thornville, OHBuilt 1967 · S/N CD-1094N1751GThaxton Todd J · Williamson, GABuilt 1962 · S/N CD-494N1758GMullooly Michael S · Redwood City, CABuilt 1962 · S/N CD-497N1759GVandergenugten Brian J · Schererville, INBuilt 1962 · S/N CD-501N1766GCallaway Ike Wingate Jr · Tampa, FLS/N CD-507N1767GFranceus Maurice Michael · Temperance, MIBuilt 1962 · S/N CD-539N1768GRl Hoffman Aviation Services Inc · Sanders, KYBuilt 1962 · S/N CD-509N1782GJts Aircraft LLC · Rock Hill, SCBuilt 1962 · S/N CD-510N1783GHarrington Perry J · Carlsbad, CABuilt 1962 · S/N CD-521N1791GPac Flying LLC · Saint Johns, FLBuilt 1962 · S/N CD-514N1793GGeorgen Auto LLC · Manchester, IAS/N CD-515N1798GMeaux Jimmie J Jr · Kaplan, LABuilt 1962 · S/N CD-512N17KCHarrison Gene R · Pendleton, ORS/N CD-169N1866CScialabba Samuel S · Emerald Isle, NCBuilt 1966 · S/N CE-60N18ARBas Part Sales LLC · Greeley, COBuilt 1965 · S/N CD-959N18EWCahill Thomas · Queensbury, NYBuilt 1966 · S/N CE-22N1929UHolmgren David J · Plainfield, NJBuilt 1962 · S/N CD-554N1941TErwin Randall L · Johnson City, TNBuilt 1965 · S/N CD-958N1960DPlane Fun Inc Tr Trustee · Snellville, GAS/N CD-118N1995AReeder James T · Ottawo, KSS/N CD-406N1CKWilson Nick · Glenwood, ILBuilt 1966 · S/N CE-30N1LVMcarthur Thomas M · Annapolis, MDBuilt 1966 · S/N CE15N1QYJet X Leasing Inc · Johnson, KSBuilt 1964 · S/N CD-798N1YMSupreme Aeronautics LLC · Haymarket, VAS/N D-1145N2007WChavez Jeremy · Fort Worth, TXBuilt 1965 · S/N CD-971N2010WHogsett Troy J · Willow Springs, MOBuilt 1965 · S/N CD-972N2019WKornfeld Roger E · Whitewater, KSBuilt 1965 · S/N CD-973N2027WMckinney Karen L · Naperville, ILS/N CD-976N2029WWilliams Steve C · Elgin, SCBuilt 1966 · S/N CD-978N202DKarschney Rich · Pateros, WABuilt 1947 · S/N D-57N2032WTodd Norman Wendell · Marietta, GABuilt 1965 · S/N CD-977N2039WWitt Ted C · Castle Rock, COBuilt 1965 · S/N CD-969N2065WSmith Lawrence · Visalia, CABuilt 1966 · S/N CD-986N2071WCountry Sunset LLC · Mc Louth, KSBuilt 1966 · S/N CD-987N2083WKindig Eric J · Sidney, OHBuilt 1965 · S/N CD-990N2098WHolland Greg R · Irvine, CABuilt 1966 · S/N CE-9N21WSRdb Leasing Inc · South Fork, COBuilt 1964 · S/N CD-787N221DBSegura Richard J III · Henderson, TXBuilt 1961 · S/N CD-407N222EFGillis Blake · Clinton, MOBuilt 1965 · S/N CD-928N2289BHollister Jet Center Inc · Hollister, CAS/N CE-178N229ESLastowski Jeffrey A · Mooresville, INBuilt 1967 · S/N CE-174N22DSSwartwout David C · Sedona, AZBuilt 1961 · S/N CD-446N22GDMagafly LLC · Bay City, MIBuilt 1964 · S/N CD-783N22WLSchauer Henry A · Fort Collins, COBuilt 1966 · S/N CE-41N232SUWard Simon James · Sylva, NCBuilt 1967 · S/N CE-172N234GLL J Aircraft LLC · Cedar City, UTBuilt 1966 · S/N CE-112N2360JReed Matthew A · Burnsville, MNBuilt 1963 · S/N CD-698
Back to AD 48-08-01