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.
N7391AMitchell Vernon · Waxahachie, TXN7391MAnderson Richard A · Sycamore, ILN7391TAngell Toby L · Stillwater, OKN7392MSantana Marcos · Concord, NCN7393MJ S Imperio Construction And Real Estate Svc/S LLC · Laredo, TXN7393TAppalachian Flight Services LLC · Huntington, WVN7393XSmokovitz Joseph M · Tecumseh, MIN7394AFreer Lawrence C III · Puyallup, WAN7394TSmith Lowell A D · Gresham, ORN7394XRinehart James A · Sebring, FLN7395TWhalen John F Jr · West Ossipee, NHN7396TFitzsimmons Robert J · Hastings, FLN7396XJons Steven R · Minden, NEN7397AWillems Scott F · Cottonwood, CAN7397MBuck Mark E · St Maries, IDN7397TDirectional Holdings LLC · Missoula, MTN7398THilliard George W · Beeville, TXN7398XSnodgrass James T · Gallipolis, OHN7399AWheeler James H · Bryan, OHN7399TLandrover Ltd · Hills, MNN73HBOrians Brian E · Medina, OHFirst renewal noticeN73JKGolden Jerry W · Ocean Springs, MSRegistration ineffective or invalidN73LHerald Gregory L · Coatesville, INN73PCMedearis Jeff W · Plevna, MTN73PMSmith David James · Fort Mcdowell, AZN73RJRichard Kent A · Sunset, LAN73TFKlanchar Flying LLC · Benton, ARN7400AHarrop Brian C · Mesa, AZN7400BHartmann Jeffrey N · Chico, CAN7400M7400m Air Inc · Auburn, ALN7400XLandrush Construction LLC · Fairview, OKN7401BSherman David B · Readfield, MEN7402BRoberts Christopher J · Andover, KSN7402TKnox David B · Mc Arthur, OHN7402XClemson Flying Club Inc · Seneca, SCN74036Pallen William T · Fargo, NDN7403TKoehn David Scott · Orange Beach, ALN7404MHrevans Cessna 175 LLC · Fairbanks, AKN7404TRaptor Flight LLC · Fort Worth, TXN7405BDennis Rick L · Poughkeepsie, NYN74066Davis Brian L · Antlers, OKN7406BKraft Tyrone H · Timber Lake, SDN7407AKremmling Flying Inc · Kremmling, CON7407GStarr Ralph H · Port Orange, FLN7408AJohnston Lynwood A · Anchorage, AKN7409TJohnson Scott E · Wausau, WIN7410TLepinsky Donald J · Whitehall, MTN7411ACoverdill Robert E · Savoy, ILN7411TMcbain Sarah R · West Warwick, RIN7411XTakagi Mark A · Richland, WA
Back to AD 94-05-05 R1