AD 77-13-21
Registered aircraft · 3,193
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:77-13-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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.
N7375PSmith Happy E · Rogersville, TNN7375YTwinco Aviation LLC · Kalispell, MTN7376PWelch Robert W · Harper, KSN7378YJohnson Bruce L · Oklahoma City, OKN7379PGlick William R · Newark, OHN7379YRegistered aircraftN7381PPax River Flyers LLC · Kennett Square, PAN7384YMccafferty Robert S · Duluth, GAN7385PAbughazaleh Ziad · Altadena, CAN7386YAlbee Philip · Cameron Park, CAN7387YLillquist Brien I · Oak Harbor, WAN7388YForward Aero LLC · Thomasville, PAN7389PNordic Elevated Inc · Eden, UTN7389YPascoe Aviation Inc · Gulf Breeze, FLN7390PGreen William A · Memphis, TNN7391YAeronautical Technical Service Inc · Collierville, TNN7392PGray Matthew R · Haymarket, VAN7394PWhittle Mark A · Crestview, FLN7396YAllen Charles M · Puryear, TNN7399PPache Keith M · Montgomery, TXN73TLucid Thought Consulting LLC · Terre Haute, INN73ZFlying Rocks LLC · Sparkill, NYFirst renewal noticeN7400YWright Amos L Jr · Enterprise, ALN7402YN5746u LLC · Dover, DEN7404PWhisler Greg A · Lincoln, NEN7404YSlowpoke Air LLC · Palm Harbor, FLN7405PClassic World Holdings LLC · Wilmington, DEN7406PAviation Collective LLC · Fort Worth, TXN7406YTucker Engineering Associates Inc · Locust, NCN7408PJeffrey Thomas James · Crestwood, KYN7409PPeters Gordon J · Salem, ORN7410YDuncan Paul J · Bartlett, TNN7412PEspyess Aviation LLC · Sylvania, OHN7413YOutka Air LLC · Aberdeen, SDN7416PDavenport Jimmy J · Hayesville, NCN7417PWhitewater Aviation Inc · Harrison, OHN7418YArmbrister Justin R · Blue Ridge, TXN7419PBollfrass William Henry III · Rhinelander, WIN741TJJackson Thomas R Jr · Spearfish, SDN7420PTurner Bryan R · Corinth, TXN7420YLegacy Aviation Inc · Stuart, FLN7421YHinkle Anthony Gray · Mineola, TXN7424PHutcheson Raymond E · Lawrence, INN7425PRiffle Christopher B · Altus, OKN7426PNehus Christopher J · Camarillo, CAN7429PSwett Frank M · Zebulon, NCN7429YDewitt Troy C · Lake Elmo, MNN7430PSchlosser Nelson L · Tucson, AZN7430YLavion LLC DBA · Zeeland, MIN7431YRegistration Pending · Lynchburg, VARegistration pending
Back to AD 77-13-21