AD 77-07-07
Registered aircraft · 27,388
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-07-07')
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-07-07')
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-07-07') 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-07-07') 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.
N105JWLayton Stephen D · Lovington, NMN105PDN105pd LLC · Ulysses, KSN105RVOurada Don A · Lexington, TXN1061ENeal Foster Trucking Inc · Woodland, CAN1061XMelbourne Flight Training LLC · Melbourne, FLN1064XActive Pilot Inc · Van Nuys, CAN1065PChisum Robert · Lorenzo, TXN1066QMoretti Anthony M · Deming, NMN1067QHard Rock Inc · Purcell, OKN1067SStahl Stephen D · Bowling Green, KYN1067YMerino Anthony S · Springville, CAN1068FDubois Marcus S · Olive Branch, MSN1068HJudd Gary F · Bend, ORN1068MWolfenden Allen K · Rocklin, CAN106ASMaster Designs LLC · Gilbert, AZN106GCJones Michael D · Warner Robins, GAN106GLVon Koschier Angelo · Lynnfield, MAN106GTGendron Paul F · Vero Beach, FLN106KSDocal Light Industries Llcname · Redwood City, CAN106LHEtling Kurt K · Edgewood, TXN106MMHutchens Steven L · Melbourne, FLN106MSKundel Richard · Cedar Rapids, IAN106RBSpeck Gregory J · Oak Harbor, WAN106RDMarinaphoto Helicopter LLC · Rehoboth Beach, DEN106SMMorris Geoffrey J · Henderson, NVN106TUDesmit Matthew L · Centerton, ARN106WTSchafer Timothy · Soldotna, AKN1071XPeter Prince Aviation Center LLC · Milton, FLN1072ESabbatino Robert F · New Milford, CTN1072QCoastal Air Inc · Groton, CTN1073FFlydreams Aircraft Group Inc · Fort Lauderdale, FLN1074TIowa Lakes Community College · Estherville, IAN1076ATri City Airframe LLC · Kalispell, MTN1076XMarston Lester J · Ukiah, CAN1078MGeorge Gary D · Humble, TXN1079MGeneral Aviation LLC · Henderson, NVN1079YBoyer Jerry D · Monument, ORN107BAFairmont State University · Fairmont, WVN107CGColon Orlando · San Juan, PRN107DSweeney Edward C Jr · Parrish, FLN107ESWalpole John W · Iola, TXN107MRMeriden Aviation Center LLC · Meriden, CTN107MSJprg Aviation Inc · Orlando, FLN107NFratti Robert B · Nampa, IDN107NDN107nd LLC · Wilmington, DEN107RARl Aviation LLC · Miami, FLN107RFStevens Matthew S · Penn Yan, NYN107RVRegistered aircraftN107SHHanson Jeffrey A · Mc Kinney, TXN107SWPanther Aviation LLC · Granbury, TX
Back to AD 77-07-07