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.
N7126SMartin Marty · Summerville, GAN7127ASeremet Cristina L · Beaver Dam, WIN7127MSlinkard Andrew L · Mesa, WAN7127SAbraham Curtis L · Byron, WYN7127TLehmer Jereme · Oxford, NYN7128AEgbert Tom · Claremore, OKN7128MReid Brian M · Boise, IDN7128SHart Brian Jay · San Marcos, TXN7128XSchmitt Rudy · Brookshire, TXN71299Hurlbert Vernon L · Anchorage, AKN7129FDavis Clint H · Paola, KSN712YPRussell John K · Graford, TXN7130AJohnston David E · Fort Myers, FLN7130FRicker Gary L · Greeneville, TNN7130SHansen Christopher H · Durhamville, NYN71311Lady Luscombe LLC · Seattle, WAN71313Albers Edward R · St Charles, ILN7131AOneill Mark B · Pinckney, MIN7131FSchoch Brayden · Fort Pierce, FLN7131TReyes Jose Daniel Cruz · Wilmington, NCN7131XEaa Charter 1093 · Midland, MIN7133APeacock Richelle L · Arcadia, FLN7133FCarrolls Auto And Aircraft Sales LLC · Muncie, INN7133TQuam Gary L · Rio, WIN7134FMejean Kenneth R · Brandon, FLN7134MTravis Craig W · Fallon, NVN7135AMoss Colin · Sparta, NCN7135FMiller Joseph A · Amissville, VAN7136ACross Frank · Huntsville, MON7136GFairchild Natalie J · Drummond Island, MIN7136SGonzalez Alec · Homestead, FLN7136TSnouffer Robert E · Mountain Grove, MON71370Jeffrey Abrams LLC · Ocala, FLN7137ACarrico Drew E · Redway, CAN7137TLeavitt John E · Palmer, AKN7138GWerenko Zandra · Cape Canaveral, FLN7138SDeaton Craig · West Alexandria, OHN7138THudson Thomas C · Bessemer, ALN7138XHalvorson Jerome B · Wyndmere, NDN7139ATimothy Scott Bloom · Chugiak, AKN713BJRiley James A · Richmond, KYN7140FLogan Gregory A · Chouteau, OKN7141AFarruggia John A · West Winfield, NYN7141TRosser David S · Lynn, ALN7141XWells Brent R · Atascadero, CAN7142XTownsend Charles D · Portage, MIN7143MMiles Richard B · Lompoc, CAN7144MKeno Dale J · Worley, IDN7144SLet There Be Flight LLC · Portage, MIN71454Javarey David J · Corning, NY
Back to AD 94-05-05 R1