AD 82-06-11 R1
Registered aircraft · 2,376
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:82-06-11-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-06-11-R1')
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:82-06-11-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-06-11-R1') 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.
N9382NGarapati Prasad S · Mount Airy, MDN9383NHall John G · Morrilton, ARN9386NMays David J · Lincolnton, NCN9390NDenison Flying Club LLC · Denison, IAN9392NWilder Bradley Alton · Cypress, TXN9394NWeller James Alan · Barnesville, GAN9398NCraige Danny D Trustee · Durant, OKN9399NYankcub LLC · North Charleston, SCN93CCRps Aviation Group LLC · Slinger, WIN93TJSale Reported · Crystal, MNSale reportedN9401CRegistered aircraftN9401NJanes Charles Dale · Cleburne, TXN9404N9404n LLC · Brush Prairie, WAN9408NCope Parrish B · Lemoore, CAN940TCMusser John R · Freeport, ILN9411NFeicht Robert E · Rincon, GAN9413NMartin Bernard · Maricopa, AZN9415NSky Bound LLC · Wyoming, MIN9417KWest Bend Air Inc · West Bend, WIN9417NPrescott Milton B Jr · Glendive, MTN941NZCumplido Luis · Rumford, RIN9420NSpace Cadets Inc · El Cajon, CAN9421NMitzoom Montana LLC · Lakeside, MTN9423NCox Ricky L · Bell Buckle, TNN9425NSpaniol Mark · Lula, GAN9426NClodfelter Chet · Roachdale, INN9427NSchool Board Of Bay County Fl · Panama City, FLN9428NYatteau Michael G · Woodbridge, CAN9430NOakley Air LLC · Oakley, MIN9435NDoran Jeffrey · Centerburg, OHN9440NEshowe Aviation Inc · East Peoria, ILN9442NClear2aviate LLC · Ionia, MIN9443NSchulz John B Jr · Marquette, MIN9447NEvans Jeff W · Hannibal, MON9448NMason Harold R · Quincy, WAN9449NCole Vincent J · Ewa Beach, HIFirst renewal noticeN944DBManning David A · Aledo, TXN9451NHorus Aviation LLC · Ashburn, VAN9453NBroody George E Jr · Berwick, PAN9455NSchreiber Jeffrey H · Mundelein, ILN9457NHermes Aviation Partners LLC · Boca Raton, FLN9458NSwaz Aviation LLC · Mesa, AZN9459NEngel Stephen J · Plymouth, INN9461NJames Neville & Company Inc · Ocala, FLN9462NLombardo Gene S · New Bern, NCN9464NTempleton Katherine M · Madison, WIN9465NStenhouse Place I LLC · Fountain Inn, SCN9466KSpanaflight LLC · Puyallup, WAN9466NWingert Douglas L · Smithfield, KYN9470NEdwards Ed · Collinsville, OK
Back to AD 82-06-11 R1