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.
N1957WDye Roger C · Pomeroy, WAN19582Olson Ben A · Gig Harbor, WAN19587Steward Matthew C A · Broken Arrow, OKN19588Kenner David · Maddock, NDN19589Eaton William I Jr · Seabrook, NHN1958VHeath Byron R · Scottsdale, AZN1959Smith Robert P · Lago Vista, TXN19590Koskan John M · Wood, SDN19592Aviation Trust Co LLC Trustee · Oklahoma City, OKN19594Jeter Ray E · Spring Hill, FLN19597Estrada Katrina · Helotes, TXN1959KEllis Brenton M · Clarkesville, GAN195GSFairfield Eugene D · Wiscasset, MEN1960KRussell John K · Graford, TXN1960VKrasemann Keith W · Chicago, ILN1961BGoose Aviation LLC · Cumberland, WIN1961CAeroslat4 LLC · Lewes, DEN1961KNeuzil Carl D · Dallas, TXN1961NMarshall Charles · Fair Grove, MON1961TReilman Robert F Jr · Colorado Springs, CON1962DTowery Daniel T III · Dover, DEN1962EAdkins Jonathan T · Belvidere, ILN1962NPowell Kenneth W · Ann Arbor, MIN1962VMorris Gray S · Chugiak, AKN1963CVan Rhede Van Der Kloot Kristin L · Charlotte, VTN1963GOlson William A · Florence, ORN1963ZMarker Nathan E · Amherst, OHN1964BHamilton James D · Daingerfield, TXFirst renewal noticeN1964ZGreene John P · Yuba City, CAN1965CHouseholder Troy D · Bridgeport, WVN1965NWixon Charles · Milton, WIN1967CRobinson Lee A · Arlington, TNN1968CPoor Ronald D · Oak Ridge, TNN1968EShaw Daniel C · Princeton, ILN1968GGiles Joseph Allen · Boling, TXN1968ZDuffel Christopher · Bellevue, WAN1969VSabala Michal · San Jose, CAN1969ZDownen David J · Murrieta, CAN196JJJones Bradley · Farmerville, LAN196MKKinikin Melvin D Trustee · Big Piney, WYN197Phillipson Justin M · Vacaville, CAN1970BSmith Steven J · Naperville, ILN1970JZarinnia Jonathan C · Delavan, WIN1970KBentley Robert H · Lockport, ILN1970MAirborne Resources Inc · Midlothian, TXN1971EHoltaway Robert F · Bullock, NCN1971KThompson Roger L · Springfield, ILN1971ZKrebs Keith C · Fort Worth, TXN1972VAbsolute Ceiling Leasing LLC · Stafford, VAN1974VBocek James C · Sheridan, WY
Back to AD 94-05-05 R1