AD 77-13-21
Registered aircraft · 3,193
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:77-13-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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.
N373Clayland Walter · San Rafael, CAN3764XAerialsmith LLC · Dunedin, FLN377HHJennings Christopher Wyckoff Trustee · Brentwood, TNN3783Midwest Fling Service Inc · Elgin, NEN37HEBjbipbip Corp Trustee · Wilmington, DEN3815EHonest Dog Farms LLC · Fayetteville, GAN38760Davis Robby E · Plant City, FLN388LBSdgair LLC · Port Orange, FLN38AGBaxter Kyle W · Tumwater, WAN390WWalter Paul F · Milwaukee, WIN393TBTom Brown Consulting LLC · Ave Maria, FLN397PCPapadopoulos Gustave · Summerland Key, FLN39CRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN3HMTalley John T · Clifton, TXN3HRDow Glendal R Trustee · Bedford, TXN3MSCarter Zac · Atlanta, GAN3SDDanish John S · Hooksett, NHN3SGN3sg Enterprises Inc · Wilmington, DEN3XEServ Aero Engineering Inc · Salinas, CAN400CJDeepe Mark D · York, NEN400EDavis Richard · Reno, NVN400FKFinazzo Joseph · Fort Mohave, AZN400FW400fw LLC · Largo, FLN400GCNorthern Sky Aviation LLC · Harbor Springs, MIN400GUTriple S Aviation LLC · Wilmington, DEN400HLSale Reported · Lamesa, TXSale reportedN400HPMorgan David W · Canton, MIN400HRDavis Gary L · Burleson, TXN400KKDennehey Patrick N · Cameron Park, CAN400LBAutumn Crocus LLC · Cincinnati, OHN400NQN400nq LLC · Gleeley, CON400PAN6105s LLC · Norwood, NCN400PPMig Aviation LLC · Sandy, UTN400SWDay Stephen F · Queen Creek, AZN400TDHardy Mikel · Twin Falls, IDN400WGRegistered aircraftN400WLHammer Construction Corp · Miami, FLN400YKarschney Rich · Seattle, WAN40193Rearden Logic Inc · Denver, CON40439Usoarflorida LLC · Fort Myers, FLN405TSRichard N Appling · Ellensburg, WAN407AFRuff Brent M · Santa Clarita, CAN409LAAnderson Wilma (Lori) · Blue Mound, ILN40DACirrus Design Corp · Duluth, MNN40JSAir Flight Enterprises Inc · South Daytona, FLN40RSSaul Gregory D Jr · Glenrock, WYN40VKSimply Living LLC · Fort Myers, FLN40VMQualitair LLC Trustee · MichelstadtN40WFGrennell Brian M · Euless, TXN415HPRichmond George H Jr · Elkhorn, NE
Back to AD 77-13-21