AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N907DRWhite Warren R · Birmingham, ALN907JMWright Flight Inc · Tucson, AZN907WFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN907WGWhisky Golf Holdings Inc · Heber City, UTN9080XNoldin John · Griffith, INN9083SRobinson Charley C · Guthrie, OKN9083UNashville Malibu Partners LLC · Hendersonville, TNN9083ZCalder Brothers Corp · Greenville, SCN908ALPrincipal Aviation LLC · Palm Beach Gardens, FLN908ATWegener Airlines Inc · Ridgeland, MSN908DBB36 LLC · Winter Park, FLN908DTGeen Hornet LLC · Wilton Manors, FLN908DUAirdu LLC · Hoschton, GAN908MMWilmington Island Aviators Club LLC · Savannah, GAN908PScott Kevin · Santa Fe, NMN908SEHarness William W Trustee · Carmel Valley, CAN908TATrianon Aviation LLC · Naples, FLN908ZUAyers John C · Narragansett, RIN9090JDieppa Pablo F · North Charleston, SCN9090NPmt Flyers LLC · Amarillo, TXFirst renewal noticeN9095SPowers Land Management Service Inc · Lyons, INN9098UGlobal T & E Inc · Mcallen, TXN909ATGo Consultants LLC · Wilmington, DEN909DCTwin Piston Aviation LLC · Salisbury, NCN909RFPastjo Aviation LLC · Charleston, WVN909SBLaguna Air LLC · Montecito, CAN909TMCaext Holdings LLC · Kalispell, MTN909VBBedalou Aviation LLC · Joplin, MON90CDCirrus Pilots Flying Group · Hillsborough, NJN90CFArq Aviation LLC · Wilmington, NCN90DMDel Martin Lp · Spring, TXN90KBSancerre Inc Trustee · Wilmington, DEN90MGEracare Aviation LLC · Wesley Chapel, FLN90RWWallace Richard · Santa Teresa, NMN90TLColorado Aviators LLC · Gypsum, CON9100UFly Mcble LLC · Huntsville, ALN91025Arctic Aviation Leasing LLC · Anchorage, AKN91045Dakota Aircraft Specialists LLC · Hot Springs, SDN9109MAr Malibu LLC · Gassville, ARN910BHb Air LLC · Arvada, CON910JVDunmire Properties LLC · Goldsboro, NCN910MFly By Night Aviation LLC · San Francisco, CAN910RHDelaurentis Robert · Oak Harbor, WAN910SAPersistent Roots LLC · Carpentersville, ILN910SGKrs Aviation LLC · Elk Grove Village, ILN910WWLundell Plastics Corp · Odebolt, IAN9111PBas Part Sales LLC · Greeley, CON9113ZKenmore Crew Leasing Inc Owner Trustee · Bellingham, WAN9114NOutlier Mt LLC · Kalispell, MTN9117JBlue Skies Malibu LLC · San Diego, CA
Back to AD 2012-10-13