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.
N5987JBoerne Flight Options LLC · Boerne, TXN5988AHiggins Jeffery D · Minden, NVN5988TInvestopia Online LLC · Houston, TXN5989ABrokaw Terry L · Three Rivers, MIN5989ESchiller Gregory L · Pittsburg, NHN5989TKnudtson Bruce A · Sioux Falls, SDN5991EWilliford Travis C · Sandersville, GAN5991JSchutes John T Jr · Port St Joe, FLN5991TDelima Joseph D · Livermore, CAN5992GPerry Aaron O · Piqua, OHN5992JLinback Ken R · Niles, MIN5993GSchoenrock Timothy · Stillman Valley, ILN59941Registered aircraftN5994BGunning Craig H · Lansford, NDN5994EMccallister Shawn D · Hendersonville, NCN5994TBundgard Peter A · Natchez, MSN5995AOanes Kenneth W · Merrillan, WIN5996ACascade Mountain Vacation Rentals LLC · Cle Elum, WAN5996GRandle Jessica R · North Bend, ORN5996ROwens Wilbur · Rch Palos Vrd, CAN5996TLopez Manuel G · Fort Washington, MDFirst renewal noticeN5997RVande Sandt Curtis B · Tioga, NDN5997TFour Aces Montana LLC · Missoula, MTN5998ACrow Todd R · Hinckley, MNN5998EAir Heritage Inc · Beaver Falls, PAN5999EBender Evan Dh · Linville, VAN599CCYoung Erik A · Prescott, WAN599SIron Pillar Properties Inc · Falkville, ALN599XCollins Curtis R · Tennessee Colony, TXN599ZSale Reported · Bertram, TXSale reportedN59ADJohnson Rand C · Galveston, TXN59GLLangford Mark A · Harvest, ALN59SGEdgren Erik J · Oskaloosa, IAN59ZRiggs Craig A · Collinsville, OKN5BNMountain Air Inc · Quincy, CAN5BTJoseph Kenneth DBA · Canton, OHN5BWThompson Aubrey C · Wilmington, NCN5DGNibler Anthony A · Klamath Falls, ORN5DTFive Delta Tango LLC · Tucson, AZN5FBRichers David M · Thornton, CON5HVOppegard Nicholas D · Eagle River, AKN5JJTuszka James M · Stevens Point, WIN5JPWard Russell S · Kingman, AZN5LPMeeks Trevor · Vineburg, CAN5NTScott Wilson A · Norman, OKN5PKClark Joseph J · Hamilton, MTN5RRMcallister Robert D · Tulsa, OKN60002Kirmeyer Dana L · Calhoun City, MSN6000ARichards John M · Oregon City, ORN6000RKreisler Curt A · Plantation, FL
Back to AD 94-05-05 R1