AD 2012-19-01
Registered aircraft · 51,501
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-19-01')
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-19-01')
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-19-01') 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-19-01') 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.
N1079JElmore Danny W · Othello, WAN1079LTradewinds Aero Group LLC · Sarasota, FLN107ACBad Attitude LLC · Lisbon, OHN107AFKummer Michael · Floyd'S Knobs, INN107AKLazzaro Chris C · Solvang, CAN107ALAero Tech Services Inc · Lititz, PAN107AMYoung Mark · Vancouver, WAN107APRegistration Pending · New Braunfels, TXRegistration pendingN107AWDust Donald E · London, OHFirst renewal noticeN107BJJanowsky Bruce G · Lakewood, NYN107CKleinfelter Myles S · Lafayette, INN107ELAa-Aero LLC · Lewes, DEN107FRjm Aviation Partners Inc · Naples, FLN107FHThree Sixteen LLC · Danbury, TXN107GASwink James E · Flint, TXN107GSSharp Roscoe A · Deer Park, WAN107HPMiddleton Trevor M · Cushing, OKN107JDDhall Sanjay · Canton, MIN107KBWatermelon Berry LLC · Fort Worth, TXN107KPPeterman Keith A · Salinas, CAN107LJRaven Helicopter Corp · Wilmington, DEN107MCVeratix Ventures LLC · Carlsbad, CAN107MECash LLC · Kersey, CON107PAPacific Fleet Aviation LLC · Rochester, NYN107PFConant Dakotah · Ocala, FLN107RCHat Creek Construction & Development Inc · Glennville, GAN107RHHenderson Robert T Jr · Sunny Isles Beach, FLN107RNHayes Pat · Pittsboro, NCN107SKFitzpatrick William M · Cleveland, GAN107SSMichael Randall L · Kokomo, INN107STBennett Edward · Church Hill, MDN107TANelson Sarah J · Anchorage, AKN107TBRohde Bruce · Fife, WAN107TLGeier Jeffrey E · Colfax, WAN107TSSmith Terry G · Liberty Twp, OHN107VJdj Endeavours LLC · Downers Grove, ILN107WTDld Aviation LLC · Ogden, UTN107XLGreene Stephen D · Granbury, TXN107XRQualitair LLC Owner Trustee · MichelstadtN107XXCovington Holdings Inc · Covington, OHN1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKN10816Van Der Merwe Coenraad · Traverse City, MIN1081JSoto Osvaldo · Myersville, MDN1082JWild Bills Aviation Inc · Tustin, CAN1082XWhitmer Ronald N · Ellsworth, KSN1082ZJohnson Henry D · Buena Park, CAN1083EDavis Gregory P · Olathe, KSN1083LBenson Mark D · San Diego, CAN1083TBaer Matthew · New York, NYN1084UGranelli Nicholas · Sherman, TX
Back to AD 2012-19-01