AD 2018-07-08
Registered aircraft · 310
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:2018-07-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-07-08')
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:2018-07-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-07-08') 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.
N586LFHaynes Life Flight LLC · Wetumpka, ALN58CMCrystal Motorsports LLC · Crystal River, FLN596LFHaynes Life Flight LLC · Wetumpka, ALN59PDiesel Acquisitions LLC · Milpitas, CAN59ZXAs 355 LLC · Gay, GAN5UVPortlock Aviation LLC · Mansfield, TXN613HAHa 109e LLC · Flushing, NYN618HRBoardwalk Air I LLC · Atlantic City, NJN621SCSouth Bay Helicopter Service Inc · Hayward, CAN631HCIntermountain Medical Transport LLC · Salt Lake City, UTN648SHAltus Aviation Management · Las Vegas, NVNon-citizen corporation, flight hours not reportedN651MCMercy Flight Central Holding LLC · Canandaigua, NYN656LFTroy Equipment Holdings LLC · Houston, TXN65CJBank Of Utah Trustee · Salt Lake City, UTN663SSLeonardo Helicopters US Corp · Philadelphia, PAN669SSLeonardo Helicopters US Corp · Philadelphia, PAN671MHMansfield Heliflight Inc · Milton, VTN68NMNorth Memorial Healthcare · Brooklyn Center, MNN69KGBank Of Utah Owner Trustee · Salt Lake City, UTN6JEEurotec Vertical Flight Solutions LLC · Eudora, KSN6VZLeonardo Helicopters US Corp · Philadelphia, PAN703SHNaval Air Systems Command · Patuxent River, MDN705SHNaval Air Systems Command · Patuxent River, MDN706SHNaval Air Systems Command · Patuxent River, MDN709CGBristow LLC · Lake Charles, LAN712MCMercy Flight Central Holding LLC · Canandaigua, NYN715RTBristow LLC · Lake Charles, LAN71NMNorth Memorial Health Care · Brooklyn Center, MNN726LFBank Of Utah Trustee · Salt Lake City, UTN72HRSeminole Tribe Of Florida DBA · Davie, FLN72SLMhm Logistics LLC · Wilmington, DEN731HCIntermountain Medical Transport LLC · Salt Lake City, UTN73AZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN749SDRocklyn Leasing LLC · Duluth, GAN756LFBank Of Utah Trustee · Salt Lake City, UTN75GGA109s LLC · Pinecrest, FLN770PATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN776LFKeybank Na · Superior, CON786LFKeybank Na · Superior, CON786MKAviation Trust Co LLC Trustee · Oklahoma City, OKN789RTIntegrity Aircraft Title Holdings LLC · Portland, ORN78LFMercy Health Life Flight Network LLC · Toledo, OHN794DMRed River Aircraft Leasing LLC · Anchorage, AKN7ADEurotec Vertical Flight Solutions LLC · Eudora, KSN7UCRegistration Pending · Greenwood Village, CORegistration pendingN802SMBristow LLC · Lake Charles, LAN808STNaval Air Systems Command · Patuxent River, MDN80NYWgb Holdings LLC · Sparta, NJN80PJBank Of Utah Trustee · Salt Lake City, UTN810MCMercy Flight Central Holding LLC · Canandaigua, NY
Back to AD 2018-07-08