AD 91-22-01
Registered aircraft · 1,525
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:91-22-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:91-22-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:91-22-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:91-22-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.
N200LDFenske Jeffrey D · Gold Hill, ORN200NMOrr Leroy A · Tonasket, WAN2029SCanyon West LLC · Amarillo, TXFirst renewal noticeN2036SLissie Flying Service · Lissie, TXN205AAHzl Hanger LLC · Drums, PAN205AWLee Kevin B · Beulah, NDN205BBHixon George S · San Antonio, TXN205BPRegistered aircraftN205CLFreedenberg Philip J · Canton, CTN205CRRlh Montana LLC · Helena, MTN205CTBas Part Sales LLC · Greeley, CON205FBennett James G · Erie, CON205FJPilots Nw Inc · Bellingham, WAN205HNTischer Jesse · Des Moines, IAN205LSky King Airplanes LLC · Lewes, DEN205NBAirmotive Service LLC · Brigham City, UTN205RTTriple D Cessna LLC · Greenville, SCN206KCKaralunas David · Anchorage, AKN2103SSan Diego Flight Corp · San Diego, CAN2105SSouthport Aviation LLC · Cape Coral, FLN210ADUniplane Inc Trustee · Wilmington, DEN210AKMaxinkuckee Aviation LLC · Columbus, INN210APRegistration Pending · Wilmington, DERegistration pendingN210ATTeeters David A · Salinas, CAN210AWJohnson Matt R · Fox Island, WAN210BJSummers Equipment Leasing Inc · Wilmington, DEN210BNBy Land Air And Sea LLC · Alto, MIN210BVPlane Fun Inc Tr Trustee · Snellville, GAN210BWSc & Dss LLC · Mckinney, TXN210BXNova Aircraft Holdings Inc · San Diego, CAN210CHOne Up LLC · Stuttgart, ARN210CUTcl Fbo LLC · Tuscaloosa, ALN210CWBeach Partnership LLC · Myrtle Beach, SCN210DCRrr Land & Cattle Co LLC · Midland, TXN210DDDwoskin David F Trustee · San Pedro, CAN210DGWashburn Stig K · Westminster, MAN210DNMartin John J · Honesdale, PAN210DWBlomberg Nicholas R · Macon, MON210EBas Part Sales LLC · Greeley, CON210EAFollis Allen J · San Tan Valley, AZFirst renewal noticeN210EGCenturion Aviation LLC · Nokesville, VAN210ETVroom Consulting Inc · Ithaca, NYFirst renewal noticeN210FBBongard Frederic S · Torrance, CAN210FGGlover Properties LLC · Mount Pleasant, TXN210GATwin D LLC · Lake City, FLN210GGWiegler Michael · Austin, TXN210GMStipe Leslie Wayne · Mcalester, OKN210GNJackson Flying LLC · Siloam Springs, ARN210GSRetail Online Solutions Inc · Columbus, OHN210GTTeufel Gregory W · Lake Stevens, WA
Back to AD 91-22-01