AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N3443Registered aircraftN34430Travland Christopher L · Austin, TXN34432Wallace James K · Rio Rancho, NMN34433Sowlemann Inc · Rockton, ILN3443MBurner Dwight L · Mc Gaheysville, VAN3443RBertrand John E · Trion, GAN3443SWilliams Forest Chem LLC · Columbus, GAN3443UHall George K · Cathedral City, CAN3443XSaporito Timothy J · Warren, PAN3443YTurner Nathan D · Nenana, AKN3444Hartman James N · Bremerton, WAN34442Valenti Alan · Bend, ORN34443Schwitters Jerry · Clara City, MNN34444Lil Red Cardinal LLC · Phoenix, AZN34445East Carolina Aviation LLC · Camden, NCN34448Schleicher Conan A · Salem, ORN3444FAtwood David E Trustee · Nampa, IDN3444LDierick Greg E · Yakutat, AKN3444NPeck Justin · Forest City, PAN3444QKeystone Aerial Surveys Inc · Philadelphia, PAN3444SBraha Thomas I · Mansfield, PAN3444THunter David Frederick · Peachtree City, GAN3444ULepton Films LLC · Tarzana, CAN3444XBrey Ronald P · Van, TXN3444ZLewanski Richard B · Sheridan, ILN34453Porcaro James · Latham, NYN3445EHicks Robert C · Atkins, VAN3445FAltus Aircraft LLC · Taylor, TXN3445LYama Air LLC · Granite Bay, CAN3445SBigfoot Aviation LLC · Shelton, WAN3445WTrembly Alexander · Horner, WVN3446Benjamin Harold E · New York, NYN34464Morgan Michael B · Stanwood, WAFirst renewal noticeN34465Brodbeck William J · Kyle, TXN34467Drust Joseph L · Menominee, MIN34469Kroll Richard L · Kalamazoo, MIN3446TR & B Air LLC · Clayton, MON3446UTempus Morgan C · Cameron Park, CAN3446XLin-Aero LLC · Conway, ARN34471Grass Dennis Lee Trustee · Grass Valley, CAN3447FEngh David Trustee · Wickenburg, AZN3447LHulst Damon M · Santa Barbara, CAN3447PSimonovich Sheldon K · Fredericksburg, VAN3447S182 Corp · Rockford, ILN3447TLocander Paul · Olney, MDN3447WStimart Rene D Trustee · Harshaw, WIN3447XRmm Enterprises Inc · Isabel, SDN34484Fingerhut Victor R Jr · Ponce, PRFirst renewal noticeN34489Plexis Management Inc · Cheyenne, WYFirst renewal noticeN3448FLarson Peter · Sheyenne, ND
Back to AD 2007-04-19 R1