AD 62-26-06
Registered aircraft · 376
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:62-26-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:62-26-06')
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:62-26-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:62-26-06') 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.
N1079YBoyer Jerry D · Monument, ORN1123WThiel Jonathan Ronald · Billings, MTN160TPContrail Aviation Inc · Cheboygan, MIN16RLKerr John A Jr · Dekalb, ILN19VTBeauchamp James W · Corapeake, NCN233SPBuchwald Greg W · Grapevine, TXN2500UFrisbie Anthony G · Dallas, TXN25DSteves Landavator Service LLC · Oley, PAN262SASundance Airport LLC · Yukon, OKN274TEBas Part Sales LLC · Greeley, CON288GHBowen Christina M · Shreveport, LAN28FFCaicedo David · Villa Rica, GAN28PABurke Jacob R · Cornelius, NCN294TWLouris Thomas W · Lake Oswego, ORN2DGAgostini Glenn · Tampa, FLN347GWAllen Air LLC · Creola, ALN347RPRegistration Pending · Daytona Beach, FLRegistration pending, canceledN5001WHayes Gregory S · Erie, PAN5004WN5004w LLC · Kansas City, MON5005WManxhuka Dukagjin · Ridgefield Park, NJN5009WRegistration Pending · Americus, GARegistration pendingN5019WShipley Kelly R · Astoria, ORN5026WSpencer Don W · The Dalles, ORN5027WJohnson Dennis E · Factoryville, PAN5029WJaycor Foundation · Buirr Ridge, ILN5031WBowers Mark A · Afton, VAN5038WMarx Karl E · Juneau, AKN5043WRushton Harold E · Nashville, TNN5047WCooper James · Indianapolis, INN5050WLadeira Victor E · Holy Cross, AKN5053WJonason David · Ocean Park, WAN5065WAddai Emmanuel · Cincinnati, OHN5069WNelson Stephen A · Milaca, MNN5071WWallace Madison F · Thomasville, NCN5072WHurst Randall S · Altus, ARN5074WWells Byron R · Bunn, NCN5077WSkyport Aviation LLC · Birmingham, IAN5080WMatzke Kevin T · Gilbert, AZN5084WShouse Robert G · Owasso, OKN5085WMartin Marlin Ray Jr · Mabank, TXN5090WJaybird Aviation LLC · San Antonio, TXN5091WRegistration Pending · Anchorage, AKRegistration pendingN5117WJorgensen-Tjorneho Erik R · Conroe, TXN5119WLe Thanh Q · Santa Ana, CAN5121WCarroll Thomas F · Independence, MON5122WSale Reported · Cape Elizabeth, MESale reportedN5125WElyon Holdings LLC · Gulf Shores, ALN5129WStanek Kenneth W Jr · Russellville, ARN5130WMccutcheon Ernest Thomas · Ninety Six, SCN5131WArias Timothy R · Tempe, AZ
Back to AD 62-26-06