AD 2002-11-07
Registered aircraft · 1,512
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:2002-11-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07')
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:2002-11-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-07') 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.
N142TWInternational Air Services Inc Trustee · Carson City, NVN143DSBen-David Meir · Woodland Hills, CAN146ZUtah State University · Logan, UTN147WDDarroh Harold W · Richmond, TXN148DSEast Ramp Aviation LLC · Baton Rouge, LAN14AJChalk 2 Inc · Apple Valley, CAN14CEFacility Concepts Developments LLC · Jackson, MSN14JHRegistered aircraftN14PGorman Aviation LLC · Bartlesville, OKN14XMMedical Diagnostic Imaging Inc · Sacramento, CAN1511WFlorida Float Plane LLC · Coral Gables, FLN1515WCenturionair LLC · Greenville, SCN1526MGarmin At Inc · Salem, ORN1526WSmith Neil Walter · Rincon, GAN1545WM T Air LLC · Olive Branch, MSN1557W557 Whiskey LLC · Superior, WIN155FRSpeed Aviation Holdings LLC · Lewes, DEN155WCTca Equities LLC · Advance, NCN155ZPennsylvania College Of Technology · Williamsport, PAN1560YPacific Integrated Handling · Tacoma, WAN1564LWhipple Cory · Senatobia, MSN1566KShaw David C · Santa Barbara, CAN1566W66 Whiskey LLC · Atlanta, GAN1567NAuburn Simflight LLC · Auburn, ALN15688Moses & Associates Inc · Gainesville, FLN156ASkymook Aviation LLC · Beaver Falls, PAN1570NUp N Down Adventures LLC · Calera, OKN157JRSoft Landings LLC · Myrtle Beach, SCN157NNewsome Jeffrey S · Blackwell, OKN158BBStubbs J Phillip · Richmond, VAN158BDJ L Aviation LLC · Jonesboro, ARN158BHB58 LLC · Granger, INN158BJPerfectus Inc · Wilmington, DEN158BMChorman Spraying LLC · Milton, DEN158KPelican Aviation Inc · Gainesville, GAN158KSBowerman Marvin · Montgomery, TXN158NCIal Corp · Lewes, DEN158PA2 Laikas LLC · Helena, MTN158RFBeech Bound LLC · Morgantown, WVN158RMWings Lc · Baltimore, MDN158RSRegistration Pending · Wallace, CARegistration pendingN158SWFern Leasing Corp · Larkspur, CAN158TBLunt Christopher K · Marco Island, FLN158TCBoyd Brent · Fort Worth, TXN158WCKing Air Properties LLC · Huntington Beach, CAN159SMMcneill Transportation LLC · Whiteville, NCN159ZIdaho State University · Pocatello, IDN15JAAdams Harry Jay · New Waverly, TXN15JUC&D Aviation LLC · Appleton, WIN15XLrb Aviation LLC · Catawba, NC
Back to AD 2002-11-07