AD 2010-26-05 R1
Registered aircraft · 1,068
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:2010-26-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:2010-26-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:2010-26-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:2010-26-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.
N125DTDt Equipment Leasing LLC · Newark, DEN1280AThrasher Sky LLC · Chicago, ILN128JLAlpha Delta Aviation LLC · Nashville, TNN12LXSwan Asset Management LLC · Leesburg, VAN131EPWingspan LLC · Holland, MIN131LGCharter Express Inc · Little Rock, ARN1326SLatitude Leasing LLC · Fort Lauderdale, FLN133NMRegional Logistic Missions LLC · Mobile, ALN134CJSkyview LLC · Wilmington, DEN136MVTransnet Aviation Group LLC · Short Hills, NJN137SHDream Global Parts LLC · Lawrence, KSN138FJEthox Chemicals LLC · High Point, NCN140FJM Investments LLC · San Diego, CAN142LXDavidson Robert M · Incline Village, NVN146EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN147CJCarlisle Capital Corp · Portsmouth, NHN147GXAltair Aviation LLC · Missoula, MTN148TWSierra American Corp · Wilmington, DEN1492JTvpx Ars Inc Trustee · North Salt Lake, UTN14GDGg Aircraft LLC · Princeton, NJN14NAAnschutz Corp · Englewood, CON150KMCcn Aircraft Holdings LLC · Portland, MEN150RJ513 LLC · Newark, DEN150SSSweetener Supply Corp · Brookfield, ILN1549ERegistered aircraftN158TWSierra American Corp · Wilmington, DEN15BYJetmax Associates LLC · Miami, FLN161MDConny Innovation LLC · Alliance, OHN167ATAai Aviation Inc · San Diego, CAN167YTriangle Mountain Partners LLC · Newark, DEN16NFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN16XYPareto Peak LLC · Salt Lake City, UTN174BFlying Farmer LLC · Wilmington, DEN175CJFlying Farmer LLC · Wilmington, DEN176CG78 Aviation LLC · Oyster Bay Cove, NYN179CJIal Corp · Lewes, DEN17AQDalila Aero Inc · Wilmington, DENon-citizen corporation, flight hours not reportedN181GD330am Holding Corp · Miami, FLN181RK330 Am Holding Corp · Miami, FLN1828SRegistered aircraftN1836PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN183WWW & W 61/63 LLC · Boca Raton, FLN184WWRoyal Air Freight Inc · Waterford, MIN1875KHcrh LLC · Louisville, KYN187AAAnton Air LLC · Las Vegas, NVN1897SJ M Smucker Co · Orrville, OHN189RBDodson International Parts Inc · Rantoul, KSN18CGCorning Inc · Corning, NYN18MZRegistration Pending · Aledo, TXRegistration pendingN18WQShort Hills Aviators LLC · Morristown, NJ
Back to AD 2010-26-05 R1