AD 82-06-11 R1
Registered aircraft · 2,375
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.
N6163HSodolak Craig A · Magnolia, TXN6164JSchumar James F · Grand Rapids, MIN6166HMccolley Gregory · Glendale, AZN6170JSeeler John A · Bristol, NHN6194HJones Frederick W · Burgaw, NCN6197JN6197j LLC · Dallas, TXN61BLLong Darrin · Rincon, GAN6208JCranbrook Aviation LLC · Vienna, VAN6222HMortenson Lyle · Kennebec, SDN6222SClear Sky Aviation LLC · Lewis Center, OHN6236CAviation Equipment Company LLC · Leesburg, VAN6238JDanish Air LLC · Wahpeton, NDN6239JBlack Diamond Aviation LLC · Cullman, ALN623WCWilkinson Craig R · Parker, AZN623WJAir Mods And Repair · Robbinsville, NJN6256CKing David M · Plainville, CTN625RSIndiana State University · Terre Haute, INN6263CKasallis Thomas G · Midlothian, TXN627FDPacific Health Care Staffing Inc · Rancho Cucamonga, CAN627FGGulla Frank W Jr · The Villages, FLN6289JS K Bound LLC · Missoula, MTN6290JMclaen Family LLC · Queen Creek, AZN6298JPlane Fun Inc Tr Trustee · Snellville, GAN6304CHarben LLC · Albemarle, NCN6320CHeme Flying LLC · Lewisville, NCN6325CCurtis Aviation LLC · Derby, KSN6345CKrajewski Jerry J · Elgin, ILN6347CXclusive Level Aircraft World LLC · Kissimmee, FLN6366CHalpin Aviation Inc · Eden Prairie, MNN6367CWings High Aviation LLC · Fayetteville, NCN6372CFair Skies LLC · Seaford, NYN6388CSpray Brothers Aviation LLC · Great Bend, KSN6399CRomanowski Mark Steven II · Clay, MIN63RLVolland Aimee C · Tavernier, FLN6403CSherwood Jeffrey J · Sacramento, CAN6424CBlock Howard M · Plymouth, CTN642CFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN643PAYablonsky Richard R · Plymouth, MNN6475CFulton Technology Corp · Caroleen, NCN64DC64dc LLC · Bishop, CAN64STStefenelli Aviation N Tr Inc Trustee · AtterseeN6507JBarnes Brandon M · Metamora, ILN6508CMurphy Matthew · Anchorage, AKN6516CBarsocchini Albert P · Friday Harbor, WAN6534CMccarthy John P · Lutz, FLN659DEEisenhauer Dwight · Lehighton, PAN65CNJohnston Charles Wc Jr · Newfield, NJN661DCParts Catalog Holding LLC · Clearwater, FLN66CSWolf Steven T · De Graff, OHN66JJWilliams Nicholas Indrais · Pickerington, OH
Back to AD 82-06-11 R1