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.
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
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.
N1742GLoftus Kevin · Pasadena, CAN1747GPalmenteri Louis J · Rhome, TXN1748GRobar Aircraft Inc · Griffin, GAN174JJRensi William C · Thornville, OHN1751GThaxton Todd J · Williamson, GAN1758GMullooly Michael S · Redwood City, CAN1759GVandergenugten Brian J · Schererville, INN1766GCallaway Ike Wingate Jr · Tampa, FLN1767GFranceus Maurice Michael · Temperance, MIN1768GRl Hoffman Aviation Services Inc · Sanders, KYN1782GJts Aircraft LLC · Rock Hill, SCN1783GHarrington Perry J · Carlsbad, CAN1791GPac Flying LLC · Saint Johns, FLN1793GGeorgen Auto LLC · Manchester, IAN1798GMeaux Jimmie J Jr · Kaplan, LAN17KCHarrison Gene R · Pendleton, ORN1866CScialabba Samuel S · Emerald Isle, NCN18ARBas Part Sales LLC · Greeley, CON18EWCahill Thomas · Queensbury, NYN1929UHolmgren David J · Plainfield, NJN1941TErwin Randall L · Johnson City, TNN1960DPlane Fun Inc Tr Trustee · Snellville, GAN1995AReeder James T · Ottawo, KSN1CKWilson Nick · Glenwood, ILN1LVMcarthur Thomas M · Annapolis, MDN1QYJet X Leasing Inc · Johnson, KSN1YMSupreme Aeronautics LLC · Haymarket, VAN2007WChavez Jeremy · Fort Worth, TXN2010WHogsett Troy J · Willow Springs, MON2019WKornfeld Roger E · Whitewater, KSN2027WMckinney Karen L · Naperville, ILN2029WWilliams Steve C · Elgin, SCN202DKarschney Rich · Pateros, WAN2032WTodd Norman Wendell · Marietta, GAN2039WWitt Ted C · Castle Rock, CON2065WSmith Lawrence · Visalia, CAN2071WCountry Sunset LLC · Mc Louth, KSN2083WKindig Eric J · Sidney, OHN2098WHolland Greg R · Irvine, CAN21WSRdb Leasing Inc · South Fork, CON221DBSegura Richard J III · Henderson, TXN222EFGillis Blake · Clinton, MON2289BHollister Jet Center Inc · Hollister, CAN229ESLastowski Jeffrey A · Mooresville, INN22DSSwartwout David C · Sedona, AZN22GDMagafly LLC · Bay City, MIN22WLSchauer Henry A · Fort Collins, CON232SUWard Simon James · Sylva, NCN234GLL J Aircraft LLC · Cedar City, UTN2360JReed Matthew A · Burnsville, MN
Back to AD 48-08-01