AD 90-15-15 R1
Registered aircraft · 826
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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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.
N5036GVagias Janet Rose · Niceville, FLN5036LAsplundh Eric · Bryn Athyn, PAN5037NTriniair LLC · Warner Robins, GAN50389Sale Reported · Kissimmee, FLSale reportedN5038EHohman Brent A · Fulton, SDN5038KPiercy Ronald S · Moses Lake, WAN5038UButler Industries Inc · Amarillo, TXN50395Registered aircraftN5039GPhronesis LLC · Tucson, AZN5039NGutman Bradley J · Titusville, FLN503DMLau Wolfgang · Cap Canaveral, FLN5040NMasi Steven A · Andover, NJN50412Ride The Kite LLC · Le Claire, IAN5041MVest Dennis · Florence, KYN5041QThille Nicholas · San Luis Obispo, CAN5041UKelley Ronald C · Deer Lodge, MTN5042JLutes David W · Berryton, KSN50436Silvano Yanez · Montrose, ARN5043GLaurie Douglas B · Ramona, CAN5043ZHsrdla LLC · Kenosha, WIN50450Loyd Micheal Kevin · Grantville, GAN50451Bottomland Enterprises LLC · Fabens, TXN5046BCocchiola Bart · Pittstown, NJN5046DSmith Roger Dale · Fayetteville, NCN5047LCamarillo Aircraft Service · Camarillo, CAN5048ALee Anthony R · Gallatin, TNN5048GChappell Flying Service LLC · Oshkosh, WIN5048TSouthwick Roger W · Dundas, MNN5049CInnovative Design And Manufacturing LLC · Johnson City, TNN5049NAtkins Mikel L · Culver City, CAN50508Atkins Shane Alan · Capistrano Beach, CAN5051QKoppikar Utpal M · Hayward, CAN5051WFox Two LLC · Camino, CAN5052NHenning David L · Port Orange, FLN5053EHusted Daniel C · West Decatur, PAN5053NForgotten Heroes Foundation · Chesapeake, VAN5054GRobbins Warren N · Chandler, AZN5054KObe Aviation LLC · Doylestown, PAN5054LMarsh John E · Washington, DCN5054V5054v LLC · Knoxville, TNN5055PElectronic Research Co · San Diego, CAN5056GLambert Danny L · Plainview, TXN5056KWest Coast Aerosport Inc · Wilmington, DEN50571Cape Cod Aviators · E Falmouth, MAN50572Ready Aim Flyer LLC · New Castle, DEN5057CG & M Aviation LLC · Kokomo, INNon-citizen corporation, flight hours not reportedN5057LBillmeyer Jim · White Salmon, WAN5058LN69px LLC · Delaware, OHN5059PVertical Edge Enterprises LLC · Chandler, AZN5060JEeds Lucky L · Claude, TX
Back to AD 90-15-15 R1