AD 72-01-01
Registered aircraft · 198
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:72-01-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:72-01-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:72-01-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:72-01-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.
N7379VPainter Lucia C · Yuba City, CAN7382VDunbar Stephen Trustee · Broken Arrow, OKN7386VJenkins Jerome D · Gays Mills, WIN7389VLascar Amado J · Urbana, ILN7600EEgmond Aircraft LLC · Lewes, DEN7601EKramer Shawn T · Middletown, INN7604EEngle Vicki L · Columbus, NMN7606EWright Thomas · Clyde, OHN7608EColvin Buster · Big Cabin, OKN7612EGallegos Arthur A · Las Vegas, NVN7613EGross J Peter DBA · Kalispell, MTN7623ERedpath Mike P · Washington, OKN7628EWelsh Christopher · Oxford, NCN7630EMelton Allie J · Goldsboro, NCN7632EBedrock Aero Ltd · Urbana, OHN7639ERosario Ted · Salome, AZN7649EHuvard Todd Hunter Trustee · Clayton, NCN7650BGoodman W Robert · Opelika, ALN7651BPolihierax LLC · Kalispell, MTN7652BWalker Brent L · Meridian, IDN7653BBair Craig A · Lake City, SDN7662BGibbs Keith L · Eaton Rapids, MIN7672BNoslen Enterprises LLC · Goodland, KSN7674BSky Monkey Tailwheels LLC · Richardson, TXN7676BBudahn Christopher W · Austin, MNN7679BSchmitz Kenneth G · Petersburg, NEN7682BBrantley Hugh L · Hazlehurst, GAN7683BTorrey Daniel B · Santa Paula, CAN7684BHergot Jay H · Los Angeles, CAN7685BBoeger Cade · Montgomery, TXN7686BFishburn Michael T · Edgewood, NMN7687BRoberts James D Trustee · Tehachapi, CAFirst renewal noticeN7691BAcrovezda LLC · Williamsburg, VAN7692BSnodgrass Randall W · Lake Tapps, WAN7695BHake Glenn W · Tennessee Ridge, TNN7699BBarton Timothy E · Belvidere, ILN7NLRegistration Pending · Royse City, TXRegistration pendingN8205RRazo Beltran Josefina · Carlton, ORN8506RJones Stephen C · Wadsworth, ILN8508RClark Douglas E · Petal, MSN8511RBrenner John M · Spring Creek, PAN8524RRieger Chris L · Sacramento, CAN8531RWise Jonathan K · Eden, NCN8533RGelinas Peter L · Burien, WAN8534RA F K Corp · Ripon, WIN8535REastep Bryan N · Hutchinson, MNN8536RRegistration Pending · South Boston, VARegistration pendingN8541RKnapper Jack · Hibbing, MNN8543RJ&Ks Spruce Specimens LLC · Alexandria, MNN8544RHunter James E · Quebeck, TN
Back to AD 72-01-01