AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N4060JDooley Bob A · Alexander, ARFirst renewal noticeN4061EHarrison Hayden F · Mckean, PAN4061FHuston Aviation LLC · Fort Worth, TXN4061JConley Rocky · Swanton, OHN4061UShreve Gary L · Midlothian, TXN4062FCharlotte Air Services · Charlotte, MIN4062NOrr Allan · Hendersonville, TNN4063AWeidman Clare D · Eagle Rock, VAN4063FHand Tod E · Copper Center, AKN4063JPoules Alexander · Hope Valley, RIN4063UHangar 22 Flying Club · Siren, WIN4063VInternational Air Services Inc Trustee · Carson City, NVN40648Aanii Media LLC · Dadeville, ALN4064AAdirondack Air LLC · Wilmington, DEN4064EHurlbert Ralph E · Raymond, SDN4064NJulian Stan T · Holt, FLN4064VCapouch Rosemary E · Medaryville, INN40652Parrott Charles F · Bridgton, MEN4065VStiletto Beaver Touchdown LLC · Evanston, ILN40660Green Kirk E · Ashland, MTN4066FGray Chet K · Midland, TXN4066VWeis Patrick A · Cornelius, ORN40673Simons Corey E · Roy, WAN4067EJasinski Jack J · Necedah, WIN4067JSkyway Inc · Wilmington, DEN4067VBas Part Sales LLC · Greeley, CON40685Pierce James C · Tallahassee, FLN4068AAvg Services Inc · Wilmington, DEN4068JSutton Thomas A · Gaylord, MIN40694Yeager And Co Inc · Boulder, COFirst renewal noticeN4069EReese Troy D · Brooten, MNN4069FDmac Aircraft LLC · Savannah, GAN4069JFdp Productions LLC · Atlanta, GAN4069UPch Transportation LLC · Monterey, CAN406BNClover Crest II Inc · Key Largo, FLN406CBRegistered aircraftN406MMDean David E · Yerington, NVN4070JClark Philip M · Caldwell, OHN4070NJorgensen Richard A · Wisconsin Rapids, WIN4070VWomack Jimmy R · Webb, ALN4071FQuebedeaux Steven R · Sunset, LAN4071JMilhous Walter L · Carmichael, CAN4071NSmith Jimmy A Jr · Albemarle, NCN40727Aerial Sign North · Lakewood, NJN4072NFuhrman Ronald A · Fargo, NDN4072VHauenstein Edgar D · Holden, MON40733Case Robert S · Dallas, TXN4073FStebbins Craig S · Glendive, MTN4073UNew Entity Corp · Hardy, ARN4073VBryant Dorothy A · Arlington, SD
Back to AD 94-05-05 R1