AD 94-05-05 R1
Registered aircraft · 26,230
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.
N89545Becker Phillip A · Chandler, AZN8954URausch John H · Fairport, NYN89550Shewman Jamison · Mt Enterprise, TXN89559Sperry Ralph R · Apple Valley, MNN89563Wiener Ronald K · Tucson, AZN89566Hammer Donovan E · Tualatin, ORN89567Registered aircraftN89568Pigg James C Jr · Etna, WYN89569Gerard Bret B · Deland, FLN89572Bernard Peter C · Fleming Island, FLN89576Qualitair LLC Trustee · MichelstadtN8957BScott Larry R · Hobbs, NMN8957SMiller Andy · Marana, AZN89580Wurm Keane L · Oberlin, KSN89581Roberts Billie J · Frankfort, KYN89583Crosby Charles Daniel · Stottville, NYN89586Phillips James A · Lake Arrowhead, CAN89587Thompson Randy L · Anderson, CAN8958BRaybourn David R · Salem, ORN8958SLeo Richard E · Malibu, CAN89592Picariello John Jr · Perkiomenville, PAN89598Phillipson Justin M · Vacaville, CAN89601University Of Alaska Anchorage · Anchorage, AKN89605Erggelet Sebastian · Napa, CAFirst renewal noticeN8960BYocum Stuart J · Kingman, AZN89611Hurren Scott Joseph · Grant Township, MIN89612Johnson Lucas G · Pleasant Lake, MIN89613Registered aircraftN8961SJoham James R · Kurten, TXN8961UKqadvantage LLC · Orlando, FLN89620Womack Madie · Midlothian, TXN89628Swift David R · West Ossipee, NHN8962BMorrison Glenda W · Lexington, NCFirst renewal noticeN89631Reeves Shawn E · Richmond Hill, GAN89632Jrh Wings LLC · Alva, OKN89633Day Britt M · Inola, OKN89635Ocotillo Medical LLC · Tempe, AZN89636Metcalf Douglas W · San Juan Bautista, CAN89639Holmgren Lorence T · Kulm, NDN8963BBeam Andrew · Benton Harbor, MIN8963UAvia Aero Services Inc · Flagler Beach, FLN89641Stanley Leroy III · Little River, SCN8964BMuehl John M · Maryland, NYN8964CHansen Douglas J · Star Prairie, WIN89654Classic Aeroplane Co LLC · Tucson, AZN89658Scott William M · Spring Hill, FLN8965RAspenglow LLC · Talkeetna, AKN8965SKaufman Jayson R · Moundridge, KSN89663Rwings LLC · Sedona, AZN89669Registration Pending · Macksville, KSRegistration pending
Back to AD 94-05-05 R1