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.
N179PCMsb Aero LLC · Middletown, DEN17BYSudac Ivan · Boise, IDN17KHHubatch Kenneth A · West Bend, WIN180SDMoore Philip R · Thompsons Station, TNN1819DSpeedcraft Industries LLC · Port Jefferson, NYN181RAPinkowski Richard · Marcellus, NYN183ACSynnes Mark A · Halliday, NDN185ACFulton Lanny G · Spartanburg, SCN188RACook Gary Lee · Ontario, CAN189PCN189pc LLC · Heber City, UTN18HDDifilippo Dennis · Hico, WVN18NCJohnson Thomas G · New Port Richey, FLN190JTravel Services LLC · Metropolis, ILN191ACLoewen Jason Scott · Wenatchee, WAN191PCBad Attitude LLC · Lisbon, OHN1923RUnd Aerospace Foundation · Grand Forks, NDN192CAVines Allen E Jr · Hoover, ALN192JHHogue James B · Spencer, TNN192MAMorgan Nigel · Asheville, NCN194AMFields Douglas P Jr · Saranac Lake, NYN198JJHubbard Jordan · Boulder Creek, CAN1997RUnd Aerospace Foundation · Grand Forks, NDN199JCHeavy Metal Air LLC · Farmingdale, NYN199SAWin Win Aviation Inc · Wake Forest, NCN19BYPeralta Jose Ramon · Miami, FLN200ZCTc Holdings Delaware Inc · Overland Park, KSN202SGBassham Diane C · Ames, IAN204SDOstern Mark Lynn · Rapid City, SDN205MAWarbird Adventures Inc · Ocoee, FLN207JJN207jj LLC · Mesa, AZN210XDRafert Steven Alan · Gresham, NEN210XTAsherbranner Charles E · Yucaipa, CAN213CRJuarez Justin · Garden City, IDN214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYN214EFMaupin Dean C · Davenport, IAN215RVJet & Rotor Aviation LLC · Sacramento, CAN217PFBixenman Kenneth J · Colby, KSN21FTNordhaus Ronald R · Ottawa, OHN221JBMidwest Corporate Air Inc · Bellefontaine, OHN222CAMorse Leonard R Trustee · Cottage Grove, ORN224KKN224kk LLC · Newport Beach, CAN225ACSafeflight Alliance Inc · Osprey, FLN225SGWilliams Stephen W · Granbury, TXN226BFRichmond Charles H · Denison, TXN227ACBoeger Cade Patrick · Oroville, CAN229BBKidd Clifford L · Monahans, TXN22LLKraudelt Diane I · Carthage, NCN22YPEmb500 Inc · Saint Petersburg, FLN230MAParker-Omalley Corp · Chatham, NYN232WMFilkins Barbara · Fillmore, CA
Back to AD 90-15-15 R1