AD 75-12-07
Registered aircraft · 338
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:75-12-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:75-12-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:75-12-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:75-12-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.
N7951QClifton James Dvid · Manchester, TNN7953QGoodin David J · Yerington, NVN7960QHartwig Donald J · Riverside, CAN7972QJett Aviation LLC · Success, ARN7997QSilva Robert L · Bakersfield, CAN799JBNiner Jay Bee Aviation LLC · Middletown, DEN799TEEaster John E II · Bremo Bluff, VAN79RJDelp Gregory E · Woodbury, CTN7LLBautista Sean P · Reedley, CAN7WKAll Above Town Ltd · Wilmington, DEN800MGSnell Marion Lea · Ackerly, TXN8034QGoins Plastic Source Inc · Texarkana, ARN8133QFinnan-Johnson Flying Club LLC · Woodinville, WAN8166QE S P Aviation LLC · Wilmington, DEN8184QJohn Richard A · Southwest Ranches, FLN81RTN81rt LLC · Middlebury, CTN8242QBirds Eye View Inc · Farmington, NMN825GSRed River Ranch LLC · Wilmington, DEN831CPConstant Pleasure LLC · Paso Robles, CAN850KFInternational Air Services Inc Trustee · Carson City, NVN85BGIsley Aviation Inc · Fort Myers, FLN85SRMccorkle Air LLC · Wilmington, DEN88JBJr Aviation LLC · Benton, KSN88LTRyan M Kearbey Dental Corp · Oroville, CAN8EPN8ep LLC · Spring Hill, FLN8TCSvenningsen Joshua J · Spring Hill, FLN9110VSmith Stephen R · Lake City, FLN91EHChristensen Del S Trustee · Friendswood, TXN923DPOlson Richard N · Vashon, WAN923TAHuelsebusch Travis · Canal Winchester, OHN92ESMarion Hill Associates Inc · New Brighton, PAN9915FKeith William F · Bakersfield, CAN9920FSmith Glenn A · Horseshoe Bay, TXN9921FReap Aviation LLC · Radford, VAN9923FLlm Technology LLC · Austin, TXN9924FMontemayor Rodrigo · Mcallen, TXN999HDEscobar Juan Carlos · Juncos, PRN9AMHangen Mark C · Flagstaff, AZ
Back to AD 75-12-07