AD 94-05-05 R1
Registered aircraft · 26,232
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.
N63287Waters Brandon J · Bushnell, ILN6328GGoodger Jerome H · Milton, WIN63290N63290 LLC · Boulder City, NVN63293Roesner Alvin R · Indianapolis, INN6329EFeigl Frederick D · Dallas, TXN6329GRegistration Pending · Brodheadsville, PARegistration pendingN632EHHuddleston Edward L · Oaktown, INN632PMatlock Rodney D · Waco, NEN6330ECollins Anthony W · Bowdoinham, MEN6330SErnst Albert S III · Buda, TXN6331GSound Flight LLC · Auburn, WAN6332ERampani Joe J · Sullivan, MON6332GJr Imaging Logistics Inc · Pasco, WAN63332Andavia LLC · Fort Worth, TXN63338Scarbrough Mark B · San Miguel, CAN6333GEule James M · Eagle River, AKN6333SVano Andrew · Carlos, MNN6333TPhillips Anthony J · Owens Cross Roads, ALN63341Puget Sound Flyers Inc · Everett, WAN63342Vmax Aviation LLC · Uhrichsville, OHN63346White Thomas L · Willow Springs, MON6334ESrygley Donald E · Muscle Shoals, ALN63359Flick Adam C · Findlay, OHN6335ECorro Lee A · Holden, MEN6335GHaslam Russell L · Meeker, OKN63362Bels Holdings LLC · Albert Lea, MNN63363Shaner John D · Tallahassee, FLN6336KFlanders Steve L · Brea, CAN63375Pocono Mountains Flying Club Inc · Tobyhanna, PAN63376Devaney Aviation Inc · Palm City, FLN63384Sa Kim J · Hayward, CAN6338EBarber Theodore C Trustee · Spanish Fork, UTN6338GEron Patrick · Hatley, WIN6338KBurchinal Sam F · Brookston, TXN63395Reiman Jeffrey Scott · Chandler, AZN63399Vogt Gerald J · Erie, PAN6339EJudge Nathan E · Coeur D Alene, IDN6339SDamico Thomas J · West Bend, WIN633TZEdwards Robert B Jr · Macon, GAN63401Evans Harold M · Dunnellon, FLN63406Searfoss Robert L · Atlanta, GAN63407Mcguire Ryan · Redwood City, CAN6340EAdams Mandy Reed · New Braunfels, TXN63412Knh Aviation LLC · Yuma, AZN63414Simonis Kenneth W · Girdwood, AKN63418Knutson Wayne R · Tioga, NDN6341EHansen'S Garage LLC · Spring City, UTN6341GKlapstein David L · Burlington, WIN6341KRiggin Flight Service Inc · Madison, SDN63420Compton John · Jennings, LA
Back to AD 94-05-05 R1