AD 77-13-21
Registered aircraft · 3,193
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:77-13-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21')
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:77-13-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-13-21') 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.
N7626PZervos Fredric W · Orland Park, ILN7626YAdamson Matthew C · Sherwood, ARFirst renewal noticeN7627PKill Stephen W · Granbury, TXN7628YLamantia Mark V · Ebensburg, PAN7630YJprg Aviation Inc · Orlando, FLN7631YMbsp Enterprises Inc · Wilmington, DEN7632YLee Kitchell · Shelburne Falls, MAN7633YMatt Younkin Airshows Inc · Siloam Springs, ARN7634PDykema Carl F · Davie, FLN7637PFyi Adventures LLC · Ocala, FLN7638YScientific Motive Systems Inc · Charlevoix, MIN7639YCaviris Homestead Farm LLC · Rollinsford, NHN7642PCollins Daniel R · Klamath Falls, ORN7644PWhobrey Andrew · Bee Spring, KYN7645YN7645y LLC · Sheridan, WYN7648YFingerlakes Wing And Rotor LLC · Seneca Falls, NYN7652POso Air LLC · Missoula, MTN7652YMetro West Ambulance · Hillsboro, ORN7653PThomason Tony L · Williamson, GAN7656PAnkney Gary L · Rector, PAN7660PRegistered aircraftN7662PRemund Richard W · Slate Hill, NYN7664PSandpiper Aviation LLC · Carson City, NVN7664YSummit Flight Academy LLC · Peculiar, MON7669POkst George S · Slate Hill, NYN7670PSale Reported · Edenton, NCSale reportedN7671YBailey Wryan T · Nashville, TNN7672PSantore William F · Laguna Niguel, CAN7672YBertrand Jason · Seattle, WAN7674PChurches Michael D · Smyrna, TNN7674YBooth James R · Nevada City, CAN7675PEhrhart Jerry L · Mount Joy, PAN7676PHanneman Robert D · Denver City, TXN7676YCoffman Robert P · Bigfork, MTN7677PHenderson William C · Grafton, WVN7678PMunday Jeff R · Waverly, GAN767KPPhill-Air Inc · Dover, DEN7681YTaft Aviation LLC · Brookhaven, NYN7683PCavel Lonnie R · Vidor, TXN7684PPache Keith M · Montgomery, TXN7685PPinkel Lawrence W · Albuquerque, NMN7685YNehrbass Douglas J · Clarksville, TNN7686YMontana Leasing Group LLC · Park City, UTN7689YGitlow Stuart · Woonsocket, RIN7692PKelly Joseph · Austin, TXFirst renewal noticeN7692YAloof Aviation LLC · Denver, CON7693PCrane James M · Clayton, NCN7693YSkywalker Flight School LLC · Adrian, MIN7694PN7694p Enterprises Inc · Dover, DEN7695YGriffith David B · Gilmer, TX
Back to AD 77-13-21