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.
N653JRRegistration Pending · Oklahoma City, OKRegistration pendingN653KS653 Kilo Sierra LLC · Palm Springs, CAN6542CLeonard Summers · Pleasanton, CAN6542UMcdade John P · Fraser, CON6544YSchwarzenberg Johannes · Helena, MTN6546NMitchell Matthew J · Penn Yan, NYN6547CJrp Management LLC · Williams, AZN654BHKdzrgon LLC · Moneta, VAN654BKCirrus Design Corp · Duluth, MNN654CDCharlie Delta Aviation LLC · Sheridan, WYN654DEDill Brice R · Glendale, AZN654DMJohnson Douglas W · Jacksonville, FLN654JRCapital Holdings 233 LLC · Fullerton, CAN654KBDonatti Fernando E · Katy, TXN654LCCirrus Bay Partners LLC · Naples, FLN654MCD Andrea Victor Brian · White Rock, NMN654MECayman Holdings Inc · Wilmington, DEN654MFPenair LLC · Monroe, LAN654PGrimm Air LLC · Tucson, AZN654PPPp Transportation Leasing LLC · Newburgh, NYN654RSR Aviation LLC · Leawood, KSN654YBVandenberg Herbert · Ruston, LAN6553V44hw LLC · Shreveport, LAN6553YCenturion Aero LLC · Coos Bay, ORN6557BFangio Mark · Mckinney, TXN655CBJlala LLC · Auburn, ALN655CDCrh Services Inc · Shreveport, LAN6561CTrtc Aviation LLC · Byron Center, MIN6562YKp Builders Inc · Pittsburgh, PAN6567YMoeller Gerhard Walter · Goshen, OHN6568XBarnes Inc · Lewiston, IDN656CDAec Ally Equipment Company Inc · Murray, UTN656MCMcintosh Justin W · Joshua, TXN656REPlane And Simple Inc · Sunrise Beach, MON656SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN656TWAnderson Leif Knut · Sidney, MTN6572YMoss G B · Bakersfield, CAN6573EZxtair LLC · Janesville, MNN6578CPapoose Air II LLC · Wilmington, DEN657CBBerichi Aviation Aircraft LLC · Fort Lauderdale, FLN657MWWaddell Mark E · New York, NYN6580XSouthwest Aerial Survey LLC · Carlsbad, CAN6582Phoenix Aviation LLC · Bonaire, GAN6582PGrand High Way LLC · Gallatin, TNN6582XMclean Bruce R · Napa, CAN6584NHartmann Wayne E · Hill City, SDN6585XNorthbay Consulting LLC · Bellevue, WAN6586WMair LLC · Lenexa, KSN65873Carpenter Steve · Batesville, ARN6588XPc Rental LLC · Ely, MN
Back to AD 2012-10-13